Personally I always liked the spaceships in Farscape. They were cool. In fact so cool I even named my son Talyn, after Moya's gunship/leviathan hybrid child.
Just as well I am not a Trek fan or he would have explain why he is called Enterprise. 
Good job he was born before Alien Resurrection - he could be called Betty!
http://application.denofgeek.com/images/m/75spaceships/main/TheBetty.jpg
I thought that The Betty was a rather nice looking ship gifted with a bloody stupid name.
Hmmph, but that is possibly just me.
I agree, The Hilda and her sister ship The Mavis were also very nice.