Yeah, I'm not sure it's possible to be overpowergunned with the Borg and Dominion on your doorstep. It was so ineffective against the former that Worf ordered it into a kamikaze attack in a hopeless attempt to inflict some damage. (Which is why Worf is not on my list of "Trek captains I'd like to work for".)
@Spence: I've read those tech manuals, but they still don't really explain the ship's form factor. I get that bits can separate, but why a saucer? Even if the warp drive is in the secondary hull, why is it hung way below the ship? Things like that. I know the real answer is "because Roddenberry thought it looked cool", but the Enterprise is so weird that you have to ask for an in-universe justification.