You're getting very close to trolling here. Please stay on topic and avoid the personal comments/sweeping generalizations, or you will receive an infraction. Thanks
If the Sovereign class was a reaction to Wolf 359, considering how one sided that battle was - it looks like a half-effort. One single borg cube can outmatch the best Federation ship by a 100 fold, where as the Sovereign class is an incremental improvement over the Galaxy class ship.
The difference is said black supership was built to fight Klingons who are in terms of technology and power virtually equal in strength. To fight the borg, it has to go beyond phasers and torpedos - which is what the ENT-E was all about really.
I think the only real difference between the Enterprise-E and the Enterprise-D as far as firepower is concerned was that the newer ship had quantum torpedoes. Otherwise, they seemed to be about the same in combat, IMO.
Yep, the Ent D vs the Borg cube is a plastic knife in a gun fight. The Ent E is like a slightly larger plastic knife.
I think that study model might have influenced Vonda's concept about the TMP era Magellanic cloud class USS Galaxy. In ST III it looks smaller than Excelsior. We saw the other thinner study model in TNG. But Ken Adam's drawings were something else again. McQuarries were smoother and more organic. Drax's spacestation and Proberts station in TMP have some of the same looks.