Dark Souls?

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.

You're just one of the many undead who try but eventually fail. One of the first characters you meet makes sure you know this. :)

Preferably a game with a big open world too, one that feels real and isn't just a predetermined path for my player.

DS1 isn't very large, but there's no predetermined path at all, especially if you get the master key. DS2 isn't as open, but you still have multiple choice of routes. DS3 is limited in this regard, though.

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

That's the hallmark of the Soulsbourne series as a whole.