Gothicomp is always a great source of inspiration, some of my favourites:
Corvette Plumbata - Francois Karun
Waaagh! Gobsmak Ork Fleet - zenithfleet
Ordo Xenos Cruiser Inquisitor Lord Rorken - Bob Pottle
Terran Tyrant Battleship - Avien
Krak' em Ork Battlekroozer - zenithfleet
Plague Fleet - Timdp
Tau Courier Merchant Transports - zenithfleet
Plague Escalation Transports - Timdp