I've been playing games since I could hold a controller basically, so 26-ish years, and I think modern gaming is phenomenal. I feel sad for you, but it is what it is. Just your loss in the end.
None of the games I mentioned have micro transactions.
Outer Wilds, 1000xResist and What Remains of Edith Finch all moved me to tears. I still can't casually listen to the soundtracks of Outer Wilds or 1000x, as they simply evoke too many emotions.
Stop conflating Call of Duty and the like with "modern gaming".
Have you played "A Space for the Unbound"? It's quite moving (I teared up multiple times) and I love the unfamiliar, to me, setting of rural Indonesia. It reminds me a lot of To The Moon, which I will assume you're no stranger to.
Maybe give it another try? I have been playing lots of games for the past few years, some vigorously. Not a single one of them has a single microtransaction, because that's an immediate turnoff for me.