It's been said already, but I actually like "Friendship One" except Carey's death. The episode itself is middling but solid, it's just marred by one absolutely horrible writing decision.
I really wouldn't object to something like that ^, a future "canon" work just outright saying "oh, Seven revived him" or "don't worry about it, Admiral Janeway went a couple extra weeks into the past and saved Carey too". It'd do the episode a huge favour.