I get this feeling when playing older god of war games. although you're literally a god, you come across some ginormous enemies or landscapes that make you feel tiny. make sure not to miss the origins collection too
Patient Gamers
A gaming community free from the hype and oversaturation of current releases, catering to gamers who wait at least 12 months after release to play a game. Whether it's price, waiting for bugs/issues to be patched, DLC to be released, don't meet the system requirements, or just haven't had the time to keep up with the latest releases.
^(placeholder)^
Project1999.
Arma 3
Playing through Baldur's Gate 3 at the moment and this feels most appropriate.
Sidenote: love your name
I don't know what the full story of Baldur's Gate 3 is at the moment, and don't tell me if you do, but I'm pretty sure we're heroes, or something special. Most RPGs you're at least a little more special than average, if not much more.
Hmm, don't worry I won't spoil things for you.
League of Legends
Jungle main. Let's go.
Daggerfall Unity fits this almost perfectly. You can become hilariously OP if you want to, but exercising some self-restraint on the custom class and enchantment screens can lead to a very challenging experience.
Running with Rifles, Ravenfield, Arma/Operation Flashpoint, Foxhole, This War of Mine, Kingdom Come Deliverance, Intravenous, Rimworld etc are ones I can think of. I hope you find what you're looking for!
Star citizen
you've gotten a lot of replies already - but I'd say in terms of feeling disempowered, fear & hunger or pathologic is great. great way to experience gruelling and cruel worlds.
try Champions of Regnum. Easily 20+v20+v20+ RvR open pvp. You do feel somewhat like a small cog in a big war machine, but with still opportunity to shine if you can perceive it.