I'm looking for games that make me feel small and insignificant
Pretty much, I'm looking for a game where I'm not the hero, I'm not the protagonist, I'm just a pawn in the big picture.
Preferably a game with a big open world too, one that feels real and isn't just a predetermined path for my player.
I also like games where you aren't clearly stronger than all your opponents like you're some sort of God so they actually feel intimidating and there is a fear of dying
You’re a small and insignificant creature in a dangerous and unforgiving ecosystem. You’re not saving the world. Even the enemies are playing by the rules. Evading enemies is often the safest option, but sometimes you must do a risky confrontation. It’s rare you even take down an enemy at all. Deaths are punishing. It’s open world, but the random placement of enemies often dictate the path you’re taking.
It has also one of the most intricate AI systems in any game. There’s YouTube videos describing it in detail, but I recommend to not watch them and go into the game clean.
I second Rain World, this game is letter for letter what you are describing, and best experienced COMPLETELY blind. I really hope you decide to give it a try, because I've spent countless hours enjoying the world.