What are stories in which you found the main protagonist more interesting than the villain they opposed? It doesn't have to be limited to movies mind you. It can extend to comics, video games, tv shows etc.
T start off, I'll use Steve Rogers from the first Captain America movie. I know people see him as boring, but I could connect with wanting to prove yourself and feeling underestimated by your peers. That and I don't have a murderous urge to take over the world.