Xcom has story. It just isn't as heavy on story like BG3. I like the story a lot. If you haven't played Xcom1, that's fine, there will just be a few things you might not understand as much. Still, the story is stand alone enough that you can play it without playing 1.

I have beaten Solasta early access. It is a solid game. Very well done. It shows players how D&D rules can work on a video game. It is more true to the 5e rules than BG3. Still, I love BG3 more. Ive played maybe 30 hours of Solasta and 330 of BG3. Quite the difference. But I have enjoyed many of Solasta's elements a lot. For being a game on a much lower budget, it's pretty darn good.

If you like turn based tactical games like Xcom 2, though, Battletech by Hairbrained is another fun game with giant mechs blowing the crap out of each other and a decent story with lots of customization for both mech pilots and mechs.

I also like the Shadowrun games, though they are more dark and are a blend of sci fi and fantasy. Hairbrained did Shadowrun as well. That's series is more story based RPG. You can only create a single custom character though.