I have to agree with the view that Picard changed as a character. Some of that was bad writing but The death of his nephew and his PTSD as a result of the Borg impact his personality. That was one thing I really liked about FC, it did continue to explore what the Borg did to him. I was really moved when they explored it in the TNG. The pain, guilt, shame, and down right trauma of the experience effected him and the Movies in a lot of ways better represented that, the show, out side a episode or two just wash over that kind of trauma. And lets not forget what the Cardasians did to him with the four lights.