It was all about excess, and I think it's pretty fitting that the 80s gave us among the largest ships of all Trek, like the Romulan Warbird and the Borg Cube. Even the Enterprise-D is the largest Starfleet vessel we've ever had
I really like this point, because it's a very unique thing to point out as the 80s is remembered for its theme of excess. And we never did see a larger starfleet ship than the Galaxy class. Why would they stop there? It certainly seems, in the canon we've been given (including glimpses of the "future") that the Galaxy design was to become wildly successful.
Anyway... as for Tasha Yar being "butch", I think it's a oversimplification. Tasha was very feminine at times. Tasha had some contradictory moments though. She only lasted one season. I think it takes a hetreosexual male with limited exposure to gays/lesbians to exclaim that a women is butch just because she has short hair. And is a securtity officer. Let's not forget that she took advantage of Data's full functionality!
On the other hand, if Picard had held a gay pride parade, I wonder if he wouldn't have assigned Tasha (under protest) to carry the rainbow flag at the front.
I agree with another poster's assessment of Wrath of Kahn and Undiscovered. Those films don't look very 'dated'. I don't use the term dated as a criticism at all, simply put I find it enjoyable to see a TV or movie and based on the production values guess when it was released. Usually I can get it down to 5 years or so, provided it was made after 1950!
I'm sure most of you TrekBBS'ers could do the same.