In TNG on TV? Never that I recall.
I'd even go so far as to say "I, Borg" and "Journey's End" the differences between Picard was emotionally in the series versus where he was in First Contact and Insurrection respectively, dealing with the Borg and his (re)action to/of stopping the relocation of a planet's inhabitants.
It's still only about twice (I'd wager perhaps slightly more) in about 7 years, so pretty rare in any case.
?
I just said it happened zero times in the series, not twice. So, yeah, definitely rare. I'm with you there that in FC it was a stage.
It's late, my reading comprehension is close to nil, I'm two hours past my bedtime, and TrekkBBS is addicting. I should go this far and no farther. Bedtime must be drawn here.