The biggest "narrative dissonance" in adventure games set in the modern day is the lack of retail stores.

https://lemmy.world/post/1322825

What are some good games that opt for a grounded approach? I agree that it is few and far between (whether that is good, bad, or indifferent is a topic for another space). A few that come to mind are Don't Escape: 4 Days to Survive (takes place in a survival situation) and Dreams in the Witch House, which incorporates shop/money mechanics and other survival management elements.

You wanna know which came ISN'T grounded? Nightlong: Union City Conspiracy. If you are in the mood for some hilariously baffling moon logic, outlandish set design and embarrassing period voice acting and CG, with a plot that makes slightly more sense than The Mystery of The Druids, give it a shot. It's basically "we have Blade Runner at home."

Guess how they travel in the cyberpunk future presented in this game: flying cars. But guess how they receive documents when out of the office? Public fax machine booths mounted on walls of train stations. That's right. FAX MACHINES. The future is now.

The game is not bad per se, it will definitely stay in your mind with its utter weirdness. Grimbeard did a detailed video on it if you are curious.

Stardew valley. The resources required to have a tool made by your blacksmith make sense and most people can’t simply walk down the road and buy a steel pickax. Especially not in a small rural town.

I think it’s a fun idea to explore.

For example, would you take a shortcut and make items appear because you’re fishing them in the pond (which makes pond a source of “outworldly” items), or rather come up with something more creative? The logistics of it can tell the story better than 1000 words on a wall made to push the narrative. Of course, at the same time, you don’t want to make this a main focus to the player, unless it’s an objective.

Commonplace Rare - TV Tropes

In video games, seemingly common items often take an excessive amount of effort or money to acquire. You may expect an item to be common based on real-life experience and even see them used all over the place in the game, but you can't pick one …

TV Tropes