As for the offline RPGs, it generally works by your team barely having what they need to survive. You get to a point where you need better equipment to move on without level grinding. Said equipment is expensive enough so you'll have to grind some money, or it's tiered in a way that the next upgrade will be obsolete by the next town you reached and you've wasted a lot of money (Dragon Quest 4, in Chapter 5).
The older SimCity games are kind of different from the 2013 edition, but you're usually getting what you pay for when it comes to power plants and water. But then again, you should also have a constant stream of money from your taxes.
EVE Online is a dumpster fire, but that's the main selling point of the game.
Depending on the game, money in Fire Emblem ranges from being a constant concern (because your weapons will need to be replaced) to being just a footnote in Fates, where it's used to buy specialty weapons.
And the Zelda games are mainly focused around by ammunition and certain pieces of equipment, but the price tag normally isn't as bad as Dragon Quest.
So overall, you basically wind up with a metric ton of gold from just playing a game if you don't have a reason to buy anything new.