I'm not actually a fan of the 2750 Aegis layout. Yes, it has a lot of guns, but most of them are shorter ranged, and they feel very haphazard in their layout. The 2372 Aegis, however...First, all of the NAC/10s on the 2372 Aegis are at least in 4-gun bays, making them excellent for bracketing fire, increasing your ability to hit at range.
Looking at other ships that are actually quite good but often overlooked:
The Cameron class battlecruiser is massively underestimated, but is actually quite vicious in its layout.
Bear with me now, but the Texas class. One change would have made this quite possibly the most vicious battleship in the game until the Leviathans debuted: moving the midships Naval laser bays to the fore-sides and moving the fore-side naval PPC bays to the midships. That would have improved the anti-fighter coverage of those massive NL-45 bays considerably. As it stands, though, it's still very good.
The Tracker class. It has the misfortune of having been published before naval comm-scanner rules were published, so it lacks one, but other than that, the Tracker is a near-perfect surveillance ship, Q-ship, or even pirate ship, since it can perfectly duplicate the Merchant class JumpShip in form and function. It's absolutely brilliant.
Luxor class heavy cruiser: there's a reason the SDS system targeted these so heavily. They're very well-thought out, well laid-out cruisers.
The Samarkand class carrier is actually an excellent escort carrier and corvette. Thrust comparable to the Vincent, a full wing of aerospace fighters, just enough anti-capital weaponry to be taken seriously, and actual point defense weapons, all in a 360 kt handy package, with enough cargo to support the fighters and the ship to spare.
The Du Shi Wang class battleship. Is it built with a specific doctrine in mind bearing in mind the budgetary and industrial limitations of its parent nation? Yes. Did that doctrine work? Mostly.
Athena class cruisers, like the Du Shi Wang, were designed around a specific battle doctrine, and it's one that works, even if it's seldom used. But, even in the absence of nuclear exchanges, it's still a viable doctrine, and it's well-suited to the work. Ditto the Cruiser-class cruiser, which came out of the same design study that produced the Athena. The only thing these ships lack, like nearly every other ship out there, is point-defense guns.
I don't know if I'd call it a great ship, but I've got a bit of a soft spot for the Black Lion I, for obvious reasons. ;)