I haven't found any of the included codecs to be any good.
I export uncompressed frames and then compress them with QuickTime Pro using H.264. Excellent quality and the video can be played on any computer with quicktime without having to download additional codecs. (or even on iphones!) In my opinion, one of the best codecs available.