While I'm partial to Romulan ships in general, I really liked the Sovereign class Enterprise E and the Defiant (as see on DS9). Also, the refit Constitution class Enterprise.
Playing Cluedo with my mum while I was at Uni:
"You did WHAT? With WHO? WHERE???"