I'm kinda hoping for a short trek or something to expand on point 2 there. I didn't mind it even though it came out of left field.
My big problems with the series overall were
1. Not much came of the Artefact in the end. I'm not sure if it was that the writers couldn't figure out hot to make it a bigger thing, or the fans felt it should have been more important, but it just seemed to be there with all these cool plot ideas and then winds up sitting on the planet and that's it? If Seven had even used the weapons Narissa brought back online this week to help defend the planet, it would have been something
But aside from that, I really enjoyed the finale and the show overall.
2.Having Picard die only to come back in a synth body just about identical to his human one was pointless. They could have kept the Irumotic Syndrome as a growing thing that eventually kills him at the end of the show, or spent all the time referring to it to better flesh out other stories, but it really stood out as unearned drama here