Well, I just got finished watching Endgame, and with that, Star Trek: Voyager.
Now, does someone want to let me in on the joke and tell me there's another episode of VOY I missed out on where I get to see the crew back on Earth? Haha, guys?
...... guys?
You actually nailed the flaws in the episode dead on. Which is impressive with one viewing. Normally it takes a few to pick up all the more subtle flaws surrounding the time travel stupidity.
That unsatisfying "it finished one scene too early... where's the payoff!?!" Is a Hallmark of when Rick Bergman gets directly involved.
As for any further closure? There is one more scene, with one character, and yes it is a follow up scene with them on earth. It is in Nemesis. You may find yourself a bit mentally and physically disoriented once the shear enormity of that one scene sinks in.
And we do sort of know the final outcome of one other character. Tuvok will go on to serve as first or second officer aboard the USS Titan. Under the command of Captain William Riker and the skilled capable hands of Deanna "get us out of orbit!" Troi. Tuvok really is freaking cursed, isn't he? While this never appears on screen anywhere, it's all from the books, Paramount for some reason outside the norm, considers the existence of the Titan and her crew as cannon. Just not the specific published stories. They even built a studio model of the Titan for a Mall Tour. The safe bet is Tuvok found some way to bring on his degenerative brain disease himself in order to dull the pain that is his life. Just when he finally escapes Neelix after seven years of hell, he finds himself outranked by Deanna Troi. That could cause even a Vulcan to start eating paint.