If that's true I'd have to discount most of TNG, I don't find the Galaxy-Class very pleasing to my eye.
Starship's don't have to be pretty to be a class all of their own, not every ship is going to have the spotlight on them, they have a function to serve that's all. The likes of the Centaur-Type comes across as a sturdy frigate or patrol cutter, brimming with around a dozen phaser banks and four torpedo launchers, whilst her small profile makes her a harder target to hit, so she is clearly a ship that can handle herself in a fight. The Curry- and Raging Queen-Types look as though they are a redesign of the same class (such as the numerous types of Miranda-Class we've seen on screen) and could fulfill the role of a carrier, taking numerous squadrons of Starfleet fighters into battle, which would make them useful for combat as well as for colony support ships, with lots of cargo space as well as a powerful tactical force that would negate having to send several starships for perimeter defense when one would do the job. The Jupp-Type could've been a scout that took the place of the Saladin/Hermes-Classes in the late 23rd century, or a border cutter, or some other support role that has quietly been in service out of the public eye but still doing a valuable job for Starfleet. The Elkins-Type could be the Nebula to the Intrepid's Galaxy, utilising some aspects of one class in the design of another, so whilst the Intrepid-Class is intended for long-range exploratory missions the Elkins-Type is more of a science vessel, since her twin secondary hulls would allow for a lot of space for labs and other research facilities, or maybe she was designed as a search-and-rescue or hospital ship. The Yeager is a little hard to justify as a separate class, seeing as how the two parts are so radically different, though there is one theory that the ship was a test for the Intrepid-Class hull, slapped onto an available body for warp field stress tests (granted not hugely convincing, but seeing as how we only saw one, then it might be unique in the fleet), though clearly it shouldn't be underestimated seeing as how it was frequently the sole ship assigned to support and defend DS9 (aside from the Defiant).