Given that they have very different writing styles, I don't feel right ranking all of them together.
I would rank "episodic narrative" Star Trek:
- Voyager
- TNG
- Enterprise
- DS9
- Original
and then rank BS:G-style "Pseudo-linear narrative" Star Trek:
- Picard
- Discovery
Picard S1 had to spend a fair bit of time on exposition and lore building, but the writing was a lot more serious than Discovery, which I appreciated. Breaking away from spending all that time on day-to-day ship activities was a nice chance of pace as well. I'm really excited to see what they do with S2. Don't get me wrong though, I love Discovery's writing too, it just spends more time on comedy and less time on exposition.