WolfBlood series has some great intros. Same with MTV's Teen Wolf.
I really wanted to get into those shows but I was just Not the target demographic. Openings were sweet, though.
Also, since there's a lot of anime in here, I'd like to posit that the English YuGiOh 5D's opening is WAY SUPERIOR to the Japanese one.
[spoili] English:
Two of the OP's I could of said we're already used. >.<
Though I did like AoT S2's OP, even if the show itself failed to deliver. LIKE SERIOUSLY WHAT THE HELL IS WITH APE TITAN AND ALL THOSE ANIMALS!? DON'T WE GET ANY KIND OF EXPLANATION!?
And the Jojo had some good ones (note if Diamond Unbreakable has a better one, I didn't get to it yet).
Shinsekai Yori has no OP, but it'd ED worked.
Game of Throne's Season 7 Teaser isn't technically an OP, but I enjoyed it's sequence just the same.
Aaaaand, there's more than the video limit will allow. >.<
The Game of Thrones intro is great. Fantastic movement, really interesting graphics. I love how they change which bits of the world are shown from episode to episode to show where scenes will take place in that episode.