Picard has some incredibly harrowing things happen to him over the series. Turned into a Borg, tortured by the Cardassians, the thing with the flute, his brother and nephew dying, all the Klingon shinanigans.
I was the one who let you know, I was your sorry ever after, '84, '85. Give me new toys and I'll decide, but I'm really only after, '84, '85.
Meanwhile in Horror Voyager Repeats: Scorpion 1 yesterday, 2 tonight. We're busy tomorrow when The Gift is one and annoyingly it's not in the Borg Fan Collective DVD set so we'll need to catch the morning repeat on Thursday. Day of Honour & Nemesis I'm not bothered about.
The answer is that by Season 7 the writing staff were knackered both by the show but also some of them were also involved with DS9, setting up Voyager or working on the Generations movie. Jeri Taylor has spoken frankly about the burn-out/stress of the period. It's why they kept going to stories about the crew's familes in that last year as there wasn't much brain space left over for thinking up stories!