Regarding the Troi thing, I think it's generally agreed the character was usually not handled very well. My own feeling was that someone who habitually looks into the dark places in people's souls should not be so perky most of the time. The only post you made after that was complaining about "bourbon and beans".
The scene of Troi getting drunk is def not in the top 10 worst scenes. In fact I'd say it's in the top 10 BEST scenes.
There may be worse moments, but my first thought was, "Dill weed. In the cabinet, second shelf to the left, behind the oregano." The two Captains of Star Trek meeting for the first time, and at some point, the writing team just said, "Fuck it, let's just have them cook."
I think one of the worst scenes, and I will likely get flack for this, is the gratuitously long beauty shots of the refit Enterprise in TMP. It drags on forever. We get it, the ship is new and pretty. The scene felt super padded out to me.
If you haven't listened to Moore and Braga's DVD commentary, you should, because they are merciless on themselves and their "We've got to do something unexpected and not some crowd-pleasing greatest-hits crossover bullshit" mindset that they went way too far with.
Insurrection has a lot of those scenes, and they had even more that they cut out. It was so obvious they wanted to make this the comedy TNG film and it felt forced. The jokes may have gone over initially to theater crowds. It just doesn't hold up for me.
Shi*zon's viceroy does his mental assault on Troi. And for only Troi? Why not go after all the crew and make it easier for Shi*zon to win? Didn't we see this done a few dozen times in the TV show? (Well, at least once, but it felt like it had already been done a few dozen times...) The next worst one is Troi all of a sudden having shiny new powers out of nowhere that aren't explained in any way. at least she got the cool lighting camera close-up thing; the direction actually was good... (though that dune buggy stuff was pointless to begin with, to the point that no amount of snazzy camerawork and lighting would make it any better.) Okay, Shinzon could have been a great character, but his ridiculously and overly contrived backstory was off-putting in 2003 and still largely is - mostly because a couple of surprisingly minor changes and script clean-ups could have rectified all the problems and made this movie genuinely gripping and compelling, with a more grounded origin than what was filmed. A shame since there was supposedly ideas in development had NEM been a box office hit.
Picture this: It's 1979. You've had reruns of TOS in all its 1960s low-budget glory. Sci-fi in general at the time was not given glorified budgets, especially since prop and set reuse are more difficult and most people do notice that prop and set recycling can and do take them out of the story's suspension of disbelief factor if overdone and I think a lot of people still had hangovers from all those "Lost in Space" episodes too... ...in 1977, in comes "Star Wars" on the big screen. Now comes "Star Trek", after all this time - nigh on a decade A potential TV revival scraped thanks to "Star Wars". Even then, nothing new that's Star Trekky came out. In the context of the original time, those scenes were jaw-dropping. That said: In rewatches, I won't deny it does get a little long and is indeed arguably padding since some deleted scenes do add a fair bit of needed plotting and context. Still, seeing ship close-ups that looked tangible, real, and had a true and breathtaking sense of scale when Star Wars just plopped a hundred whiz-bangy ships on screen* and faster than anyone two hours after eating a steak that had been left in the sun for eight hours would plop. That was innovation on top of a new f/x style that was already innovative in 1977. and only Trek did it. At least for only this one movie. Save for some f/x recycling, which padded out TWOK at the start but - at the same time - was using it as a mini-reboot of its own, given the costume changes and other visual/tone alterations. (Well, season one TNG also showed some needed scale as "11001001" also did a really neat interior shot of the big-D with umbilical tube latching onto it with figures walking through, which still looks impressive. Triply so, considering that was a ginormous matte painting of the ship that they had used. It looks marvelous. and brownie points for the figures in the observation room walking during the opening credits... great stuff.) But... that first viewing was a true proverbial feast for the pupils, which will have dilated to the size of football stadiums for those in the audience, which is a partial reason why TMP raked in thrice its budget and green-lit a sequel, albeit with some trepidation by the studio as another costly film may not get the same level of returns, having read the critics' reviews of the time. And that's the ultimate point: the transition of this to the big screen, due to the factors precipitating it, were huge. TWOK's makers knew they had to up the ante for character and plotting, and not just because the critics pointed out the lack thereof in TMP. * to be fair, TESB shows Luke hanging onto an antenna after falling down an amazing distance that would turn any human into jam for toast, and later the heroes are shown looking out a large window as the camera pulls back.. but, as Trek was inspired by Wars, Wars was inspired by Trek as well. (and weren't the f/x were done by some of the same people? I'll have to look that one up... but all those movies look gloriously awesome.)
Scotty hitting his head in TFF. Not only was it very poor writing and a lame attempt at comedy, but the way it was shot was very amateurish. It was just completely embarrassing. I know that James Doohan (RIP) was a team player and didn't really complain about anything he was given, but he had more than every right to refuse doing that scene. It was just so out of character for Scotty.
I went to a premiere screening which was largely attended by fan groups, and it got quite a few laughs. That contrasted with a couple of general screenings, which got pretty much crickets (and one walkout).
I'll always remember people guffawing during Nemesis. There's a sequence that's supposed to be powerful when Picards rammed the Enterprise into the Scimitar. We cut to a prolonged exterior visual with no music. At the showing I was in a good deal of the audience laughed. Riker fighting the Viceroy over some weird chasm always bugged me. But STDSC demonstrated that all starships are bigger on the inside!! But as others have said, the manual steering column , the cringe singing in the shuttle, Data being a floatation device and some of the "jokes" like boobs firming up.....Insurrection really did suck.
Insurrection sucked for another reason - the love interest of the week. For me, the episodes and films where there was a love interest of the week were often the weakest and most boring to watch.
This is false, and an oft-repeated game of Internet telephone. Phase II was already dead and the choice had been made to turn In Thy Image into The Motion Picture before Star Wars ever hit theaters.
For me the worst scene has to be something out of Insurrection or Nemesis. It could be the scene where Picard goes rogue and then the crew show up in their coordinated uniforms of who is going to the planet and who is staying on the ship. It's just lazy in a way that it knows it's a film and these aren't real people so it doesn't need to do that bit extra immersion. or the dune buggy scene. The dune buggy scene pissed me off for shooting the natives, like it's fair enough it's self defense on Picard but these guys were literally the invading aliens to the natives. Putting that against "Who Watches the Watchers" or other Prime Directive shows where they try at least some stealth just makes it feel so strange. There's probably others. Insurrection though has a deleted scene better than the entire movie.
Oh yeah, I’m glad it’s not just me; that moment annoys me so much! It totally brings me out of the scene.
Another terrible scene from Insurrection was Picard dancing the mambo in his quarters. Very embarrassing!
While we’re calling out Insurrection, the shuttle chase with the HMS Pinafore singing was just excruciatingly unfunny. Hardly any of the humour in the film landed. It was just horribly awkward and strangely self conscious. Kind of like a drunk uncle making really unfunny jokes at a family gathering.