They should have let Picard die. The scene where he says goodbye was emotional, I felt a little teary eyed myself!! But then they ruin the best scene in the whole series by bringing him back to life in the golem.
What I actually thought was going to happen was the after the federation ships arrived. That the portal was going to open and the synthetics ships were going to invade our Universe. Picard in a last desperate bid to save everyone would send the ship he was in on a collision course with the Portal. Sacrificing himself and the doctor and closing the portal but not before some super powerful synth ships got through. His Sacrifice would band all three groups together, the Romulans, The Federation and the Synths on the planet in a common cause, to defeat the intruders.
Of course the battle in space looks like a lost cause, with heavy losses on Romulan and Federation sides. But, down on the planet, the Synths, with 7 of 9's help, manage to get the Borg cube up and running. And with that they manage to turn the tide of the battle in space. And the Federation, Romulans and Synths all leave in peace and harmony for ever after and the day is forever remembered as Picard's day. Etc. etc..
I think that would have been a better ending myself. AS an aside, I thought the scene with all the ships jumping in was so poorly done. Every ship looked exactly alike!!