I love the way they handled this in Doom Eternal - 6 out of your 7 basic weapons are matched in pairs, so you have 4 ammo types, but very low max ammo count for all of them. Instead you can pretty easily refill your ammo every ~20 seconds (using your chainsaw on an enemy drops ammo, and your chainsaw regens one fuel every ~20 seconds).

This means you never have an incentive to use weak weapons, EXCEPT for if you’re waiting for your fuel to regen. What makes it work is that your “weak weapons” changes depending on the enemies, as every enemy has at least one weakpoint for one of your weapons.

So instead of making you play cautiously and conservatively, Eternal wants you to always use your best weapons and to aggressively push forward. This type of gameplay isn’t for everyone, but as someone who usually ends their games with almost all items because “I might need them later!”, Eternal really allowed me to just have fun with all the best stuff it has to offer.