TNG and V shouldn't have lasted 7 seasons. They ran out of steam by Season 4.
"The Inner Light" was season five.
The show was running out of steam in the seventh year, though.
They should have ended TNG in the sixth season. Replace the last two episodes of that year (Timescape, Descent) with All Good Things and that would have made a good final season.
I've always resented Generations for how many mediocre episodes were in the final season. In an attempt to rush into the movies, they ignored the show.
I could care less about VOY. There was never any steam there in the first place.