I haven’t watched disco but I agree with you that Picard plot wise was kind all over season to season. I also didn’t really have any interest for prodigy after giving it a try.
So with that said, strange new worlds is far better and it feels like old trek to me and I can’t wait for the next season, same with Lower Decks but in a meta jokes kind of way, not for everyone of course.
As you eloquently pointed out, there has been a lot of bad to mid trek, but some of the new stuff is quite good too