Picard becoming a robot was downright offensive. To the character and the fans.
And the fact that it was “handled” so casually made it all the worse.
^^this
If there had been a multi-season arc or even moment-of-brilliant-idea as to how to reverse it... even Q snapping his fingers would be good enough, though that too is a bit obvious a solution and when everyone heard Q was returning, everyone was hoping he'd do just that. The remaining seasons just didn't know what to do with the idea, despite all the exposition put into a synthetic auto-stop function. Hate to say it, but PIC had an easy way out for the robot issue but didn't do it. That's arguably worse than STID's resorting to "magic blood" as a "get out of drama card", and the poll question would have been a lot easier had Q snapped his digits.
Still, PIC tried being original and also had to deal with the possibility of Sir Patrick not returning, so the moment possibly being rushed and then not knowing what to do is easily more forgivable than a cheap joke role reversal in STID (a movie that I think is better if they kept it all going with John Harrison and not make him into wannabe-Khan; ID had plenty of narrative and dramatic weight without needing to use an old character as a crutch. Plus, Stewart elevated Picard above the scripting. Qunito's performance tries hard, but the script was forcing the "Vulcan Spock Dealing With His Emotions"(tm) routine yet again and way too much. That said, Kirk sacrificing himself by saving the crew is probably the best way Kirk could be killed off. Though kicking into alignment what is clearly a very big and heavy piece of machinery strains credibility in that regard. (or are the elements designed to be rotated and it was stuck out of position until Kirk's kicks loosened it into ooperation where it finished a self-realignment procedure?) Still, the scene focusing more on Kirk's action and that was well-handled overall, it's easier to roll with. It's all a little sappy and soppy, as with most 21st century sci-fi fantasy, but I'd argue the scene still earned the audience's emotion.)
PIC gets my vote, despite the behind-the-scenes issues. And, as
@Lord Garth said, PIC did utilize a more original idea than mere role reversal. Props to that for sure, but the fan backlash and then nothing being done or addressed was a downer. The more I think of it, maybe I should change my vote to STID. It's a tough call, for both good and bad reasons for both situations.