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
I think you'd like the Souls series by FromSoft.
I only have played Elden Ring, but I think it fits your description really well. And from what I've heard, the rest of the Souls games would fit