Well from least to most...
NCC-1701-C.... let's face it. I don't want to die.
NCC-1701-B... With Captain Incompitent? Only bright side is that I could possibly be running the place within a month.
NCC-1701... Some great adventures, great crewmates, poor living conditions.
NCC-1701-A... Same as above, though slightly improved.
NCC-1701-E... Lap of luxury and the final frontier? What's not to like save that action hero Picard is captain.
NCC-1701-D... The infamous space hotel! With great missions, and philosopher Picard as captain.