The first season is rough. Season 2 has a few glimmers of what was to come. The episodes "Measure of a Man" and "Elementary, Dear Data" immediately come to mind.  Season 3 onward are great. Picard season 3 is basically season 8, and is also a great story to end off TNG.