I upgraded from CS3 to CS6.
The H.264 (MP4) exports are so much better it is amazing. There used to be tutorials on how to get good YouTube videos. Now we just export to a YouTube (or Vimeo) preset in HD and it shows up darn near perfect.
I can import CS3 projects into CS6 without a problem.