I'm a bit annoyed the season 2 finale seems to basically be a clip show if Riker and his sweet lovin' with the ladies. I had hoped it would be a dramatic face off with the Borg or something like that.
The whole 2nd season suffered from the 1988 writer's guilde strike. It was shortened to 22 eps (instead of the regular 26 eps that every other season of TNG has) and budgetary changes also played a role resulting in less episodes and almost no money left towards the end of the season. Bud they HAD to deliver another episode. They couldn't even afford some of the main actors to be on set for a whole episode, so the only solution they saw was that awful "clip show" to end the season with, surrounded by a very thin frame story with Riker in the coma.
You can read a little more about that here:
https://en.wikipedia.org/wiki/Star_Trek:_The_Next_Generation_(season_2)
What I would love to have seen is the aftermath from the characters, how they come to terms with what they've been through
So you must have loved the 2nd episode of season 4, because "Family" is one whole episode doing just that and nothing else.

And there were a few more, later on, when they concentrate more on the family and relationship matters. They did all that.
Characters from the past do return! Moriarty, Lore, Data's "Father", Q, Lwaxana... just to name a few. I think for a "story of the week"-show, which TNG was, they did that very well, sometimes even more than they were supposed to for a story-of-the-week-show, so in that point i can't agree with you.

And almost every season does have at least one additional two-parter (apart from the cliffhanger) as well!
I agree, watching on Netflix you can see how long is left of each episode and it's a bit formulaic that the show is all neatly wrapped up in the last 4 or 5 minutes.
Again, it's a story-of-the-week-show, and which of these shows didn't resolve their issues in the last few minutes? Which movie doesn't? Which book doesn't. Of course there are exceptions, but it mostly works like that. Of course it's formulaic - it's the formular of a weekly show based on self contained episodes. Same way you have cliffhangers at the end of serialized shows, as that it
their formular.

DS9 went other routes - but with that show it was a different order from the network, they wanted to try something else.
But both shows did very well taking all into account imho.