You could try searching “character-driven sci fi” or fantasy. Some will still be space operas, but it should pick up what you’re looking for too. Could also look into “hopepunk” for a break from angst, but I don’t actually know anything about it.