Janeway is great! I like Voyager for its tendency for standalone episodes (so you can pop in and out of the series anytime and not have too much trouble following it.) And yes, they do make it home! I think it would have been cruel otherwise lol

Yeah, I'm still mad about it! I think I'd probably like the later seasons of Discovery from what I've heard, but I definitely didn't start out with a great impression of the series