Outside of Rogue One, I have found little joy in any Star Wars stuff since the original trilogy, your comment actually makes really interested in checking out Andor
I would share similar feelings.
Andor is great because it’s largely disconnected. They don’t rely on any big major cameos, there’s hardly even Jedi or Force involved. It’s just a standalone story in the same universe. Honestly, the same things that made Rogue One great make Andor great.
I don’t think you’ll be disappointed, unless you wanted more Skywalker Family Space Drama.
Andor is a prequel and was written and directed by Rony Gilroy, the writer of Rogue One, and it’s mostly a pre-rebellion political drama with less emphasis in the pew pew (compared to the other Star Wars shows at least). And I’m surprised Disney allowed something so unapologetically antifascist without forcing the writer to tone it down.