No simulating reality is not necessary but abstract and nonsensical doesn't feel good in RPG's either. After all wargaming is the concept of simulating battlefield scenarios with tabletop means.
And with computers to help us simulate and adapt there's even less need for abstraction in general, as dice rolls get replaced by computeral calculations.
I'm playing Underrail right now and while it's a amazing game one thing I dislike is cooldown on Grenades. Stuff like this just does not feel right, it's too gamey.
And it's not like weapon damage scaling with level is the only way grinding can turn into powerlevel. It can be solved with simple things like buying a new weapon for money you grinded, getting more accurate with it, upgrading the gun or all of this. Scaling damage directly from level is just the most abtract, most obvious and most uninspired way of doing it imo. If some dude is not able to visit a shop to buy a more powerufl gun maybe RPG's are just not his thing.
Give me some believability if I'm supposed to care about the setting, my character and the game. I'm would be totally cool with a perk that turns gun skill into a damage bonus, as you are able to hit vital organs regulary for example.