What about recent games like:
- Heavy Rain
- Beyond 2 Souls
- Detroit: Become Human
- Witcher 3
- Horizon Zero Dawn
- Mass Effect Series
And then there are classic adventure type games from http://www.WadjetEyeGames.com
Those don't include any micro transaction and you pay once upfront.