Steamrunner, Norway, Sabre and Akira all take joint first. The first 3 are just ridiculous and should, if used at all, have been pitched only as alien designs. There are several major races that could have used them. They all look sufficiently alien. The Akira was an example of over-indulgence. The basic layout is appealing and I've toyed with deflector/saucer combinations similar to that myself, but the devil here is in the detail and the detailing just isn't consistent or even in keeping with TNG-era trek.
All were, it seems, pet projects of artists and the fact that all have the most spurious, off-the-cuff class names that make no effort to even sound historical, never mind using historical references as a basis as has been the traditional practice, only underlines the fact that they are the extreme odd-balls of recent trek ship design. I ignore them whenever possible.
Now, you all bash the Yeager, but is that only because when you look at the Yeager, your educated eyes see half an Intrepid surgically grafted onto the remains of a Maquis raider? If you ignore the raider and try to view the design "cold", it actually has some merits. For instance, I much prefer the combination of nacelle design and nacelle pylon angle with the Intrepid hull. I think that aspect is better than the Intrepid class design. Also, I prefer the beefier, chunkier look of the stern of the secondary hull to the vanishing squib that is the tapering stunted tail of the Intrepid, which ends suddenly in that rounded little snub of a hangar and makes the entire secondary hull and tiny little nacelles look completely out of proportion with the bulbous, over-weight, pody triangular hull (this is most apparent in profile views. The ship looks quite good head on and from the forward quarter).
I once had the thought that the Yeager class is as close as Starfleet will ever come to the look and feel of the Bird of Prey!
Cheers,