I agree with a lot of what you said about TNG, Wayne. I'm actually watching it right now in the background The characters come across kind of fake and a little too altruistic. They certainly like to make it a point that humanity has been "enlightened" and no longer has wars, violence, hatred, etc. A little too idealistic, I'd say. I love the character "Q" though! He's my favorite Trek character of all time out of any of the series.
I get a lot of flack from other Trek lovers, but Voyager is my favorite series. The Doctor is a riot and the stories were well done. Janeway does take some time to warm up to. She gets better after the first couple of seasons. You can cut the tension between her and Seven of Nine with a knife!
As for the new Discovery series - I watched it and didn't care for it too much. It really disappointed me. Almost as disappointed as I was when "Enterprise" was taken off the air after only 4 seasons. I just can't get into the new Klingons!