I thought that the first meeting between Picard and Sisko was hamstrung by the usually-excellent Stewart's bizarre way of playing Picard as seeming to be angry at Sisko for bringing up an embarrassing moment from the past, kind of like a senator would get angry if some of his frat buddies showed up at a Republican convention and told everyone he once kissed a dude for a bet. I could understand if Picard was at that point burnt out from meeting people whose family and friends Picard had killed at W359, but he isn't burnt out, he seems genuinely emotional and angry that Sisko dared to bring up that time Picard murdered his wife.
The characters tended to act differently on other Trek shows, all the same - I recall Siddig El Tahir El Fadil El Siddig Abderrahman Mohammed Ahmed Abdel Karim El Mahdi was just bizarre when he appeared on TNG.