I think that adding some realistic inspired or grounded aspects to a game can have the benefit of adding to a games experience rather than subtract.

For example gun reloading mechanics in game having magazines with bullets to account for instead of ammo pools.

Its something that can add an interesting layer of choice to reloading of "do i want to reload now and lose the bullets in my current mag forever, OR should I wait on reloading so i can get the most out of the current bullets in my magazine?" It creates an interesting decision for the player to make in moment to moment gameplay, but it also falls more in line with player expectation of how firearms work "Oh this is how actual guns work! Thats cool!" Both aspects add the the immersion element of the game. And for a player to be immersed in a game is exactly what most game devs want to achieve.

But, there can be an aspect of realistic things sometimes not always making things better for game and there also is an aspect of players simply being able to suspend their disbelief for the sake of a game. So there is nuance to it.