I’m hooked on Marvel’s Midnight Suns right now. It’s a little bit XCOM, a little bit Persona, and some deckbuilding on top. Some exploration and light puzzles in the hub area between missions if you like, mostly for the friendship/lore/cosmetic stuff. Got it free from Epic last month, but I’d say it’s at least worth $25 or so if you find a sale.
Edit: Also Nico Minoru is a possible party member, and I fucking love Runaways.
Gathering materials does suck, yeah. Rarely an activity I enjoy in any game.
I can respect the opinion of wanting to skip the social parts, that’s definitely not for everyone.
Some of them I really like though, like Nico’s always doing these side-eyed references to movies without actually naming them (Pulp Fiction, The Room, etc.)