As someone who despised Discovery, and avoided Picard, I’d recommend checking out SNW at a minimum. Lower Decks is also great, but I get it if the jokes and aesthetics don’t appeal to you. SNW ain’t perfect, but it’s well worth watching. Definitely on par with older Trek shows.

I get the burnout and the alienation, I’ve felt the same. But I think you’re doing yourself a disservice by letting Disco and Picard put you off of all the new shows. Anyhow, good luck 🖖!