Starsector is definitely a sleeper hit building a cult following. I wouldn't have heard of it if not for a friend of mine. If fantasy settings don't typically do it for you, you can encroach on a lot of things that people like about Divinity and BG3 in the Wasteland games. Wasteland 1 is an old RPG that's almost a text adventure, but Wasteland 2 and 3 are pretty modern. Cyberpunk also got a huge revamp right before its latest expansion drop, so even the original game's RPG systems and world systems work very differently now, and there's a lot of positive buzz behind it (I haven't gotten to it yet myself, but I liked the launch version).

For fantasy settings, definitely don't play Wargroove for the story, but one thing I learned to enjoy about fantasy stuff is it can create a rock/paper/scissors of strengths and weaknesses of classes/races that you can't quite hit in most believable sci-fi settings. I never got far into Divinity, but one thing that really worked for me in BG3, apart from its production value, is that it doesn't just bombard you with lore. It gives you the bare minimum setup you need to get going, and then it diagetically fills you in on the larger world as you go, with dialogue that doesn't feel like an info dump, much like Game of Thrones managed to do. Plus, IMO, there are far more interesting tactical options in BG3's combat than in XCOM; and I love XCOM.