Since you’ve already watched the relevant parts of Discovery, I’d recommend SNW. It spins off directly from Disco season 2, but it’s more episodic and has a wider tonal range. Some episodes are dark and serious, some are plain goofy. Overall you’ll find it much more light hearted and adventurous than Disco.
Otherwise, I’m a big supporter of starting at the beginning. Give a few episodes of TOS a try. Yes, it’s a product of it’s time, but it still holds up as great TV. It’s also one of the few Trek shows that really hits the ground running quality wise - the '90s series tend to take a few seasons to rev up.
Yeah, definitely not. Picard and Discovery were very serialised, as were the later seasons of DS9, but outside of those you can pretty much dip your toe in to almost any episode and not worry about getting sucked into a whole arc. It’s probably best to keep a low-commitment mindset and skip around a bit until something really works for you.