If its done to offer great immersion through features, and interactions that draw inspiration from the settings, and times the game is set in, then it's fine. Like Mafia 1, and GTA SA have to offer so many interesting details to immerse the players, and none of them felt like they are hindrances to actual gameplay, rather more believable and fitting for the game world.
But realism for the sake of realism is something I strongly dislike in video games because they force the players to accept those illogical changes without any purpose being served from actual gameplay standpoint other than, "hey, it's a serious game, so xyz feature doesn't make sense because it doesn't fit the tone, or the protagonist"
Like, seriously? You can have an airport, but flying planes breaks the atmosphere, or tone? You can fly a helicopter but somehow tanks don't make sense, even though they also fall in the same category of military vehicles. I can list many such changes that never made sense to me.
Having realistic physics, driving and shooting mechanics, bringing more believability to the cops and their actions, etc are the kind of changes that I'd support (if done right) in making the game realistic becuase it serves a good purpose in upgrading the gameplay and taking to the next level of immersion that isn't too predictable, dull and boring.