The opening title sequence of Skyfall is rather interesting, at least what can be seen of it:
Though not enough dancing girls...but at least there are more than in the shitty Casino Royale title sequence.
Skyfall's title sequence is like walking through a haunted house. And what was with those Chinese dragon eel things?
I think my favorite title sequence of the Brosnan/Craig (post-Maurice Binder) era was the one for Tomorrow Never Dies, where technology is the theme.