I agree with and second many of your statements in here. Well said! A couple specific points I want to highlight:

Paul and Hugh

I really enjoyed those plots, especially about loss.

There was also no single overarching plot, so Picard could play a flute and live the life of an alien for a whole episode without derailing any story plans. The “monster of the week” approach also helped inspire some real good moral and philosophical debate that would otherwise never would’ve been written into a single story, but also some of the most cringeworthy TV I’ve seen.

I think this is the core of the issue for what I enjoy and don’t enjoy with many Star Trek shows. Surprisingly to me, Expanse does this fine whereas Trek/Who/SG-1 would trip over it and have.

In general, great reply with excellent points. Thank you!