well, I think I know what New Hampton Yards might be working on in the future, as soon as worfie gets back to the houseboat. Ambassador and (as far as I'm concerned) Excelsior both need a power-tune.
Personally, i think Amby's got the same delay problem the Excel's did...probably a 10 year stall due to a design goof. ambassador probably config dates back to the 2310's.
and, yes, i see someone's noticed the flip-flop between series and concepts.
Gene made OS a space western, and had to take the brainy elements out that he wanted to stick in in the first place (which is why he had to make a second pilot). the OM era built on the original cast's rep. next G, however, went to the brainy stuff gene wanted in the first place, and was practically booed off the Paramount lot, till Riker grew the beard (Gene rehashing the OS episodes didn't help the first two seasons). that's why all the ships were toned down. the Post-Khitomer era was a detente era. after gene died, the guys who took over tried to put the action back in. the succeeded well enough with DS9, but Voyager was so inconsistent (and full of cheezecake) that even the actors got annoyed! then there was the prequal, Enterprise, which EVERYBODY said sucked. I'm still trying to figure out why, but I think it's because they crossed OS and Voyager concepts.
one of the classic novels points out one of the reasons for a tone-down, as does the "alien worm" conspiracy ep in NG, ST:Insurrection, etc. Starfleet has been tring to find a balance between exploration and millitary mode. it doesn't help that in every generation, a millitary nut pops up who wants to put butt-kicking back into Starfleet. Ambassadors come from a time when there was less to worry about (the Klingons burned out and were recovering, the romulans were off sulking, and, most likely Section 31 was behaving itself), and switched to the explorers angle, which is why they were so whimpy. the pendulum started swinging the other way again when Q dropped the D in the middle of Borg sensor range.