Season 1 is awful. Season 2 is awful. Both have the occasional high point that is pretty much entirely unearned.
Season three is a clunky, but well meaning apology for the previous two seasons and all of the TNG movies. It’s fan service, yes, but compared to seasons 1 and 2 it is Shakespeare. Actors get to act. Some actual drama between characters that never got a real chance to have those scenes before. Like “All Good Things” it’s not perfect, but it’s good enough to be a satisfying ending.