As I've said before, for all I love TNG (in that way of loving it despite it's issues) I can never strongly defend seasons 6 and 7 too much as they contain my fewest percentage of favourite episodes and even the ones I do like often fall into the unbelievably silly category (Sub Rosa) anyway. It really felt like it was going through the motions by then.
But in fairness, that happens to most shows/franchises that develop their own procedural components.
'If the Apocalypse starts, beep me!' - Buffy Summers
'The sky's the limit.....' Jean-Luc Picard, 'All Good Things'
courtesy of Saquist