My favorite title sequence is still the original Tom Baker sequence. I also like the latter Pertwee title sequence and the Eccleston title sequence. The colon Baker and McCoy era ones were irritating.
The new "cloudy" one is okay. I don't like that the changed the tune so much though, it was bad enough that the changed it for series four.