Do TNG's Final Three Seasons Hold Up?

https://www.youtube.com/watch?v=uT_-5mtzSYM

Star Trek: The Next Generation's final three seasons were marked by subtle but real change. As the show began to drift away from moral and sociopolitical commentary and more towards character drama and pure sci-fi, some thought it was overstaying its welcome. Is this reputation deserved?