Sure! I'm not sure how non-depressing you want them, so I've played it safe and picked out ten fiction podcasts that I've found good pick-me-ups:
Absolutely No Adventures: (fantasy) A young baker is the chosen one of about a dozen prophecies. He's happy to help out, on the condition that he will be going on absolutely no adventures.
Community Cat News: (Comedy) A radio show by cats, for cats
The Far Meridian: (Slipstream/magical realism) An agorophobic young woman wakes up to find her lighthouse home has moved somewhere completely new overnight. As it continues to travel, she uses the opportunity to look for her missing brother.
Middle:Below: (Supernatural/ Urban Fantasy) Two humans, a ghost, and a cat go on various adventures together to fix ghostly problems.
Sidequesting: (fantasy, adventure, all-ages) Rion is an adventurer like no other: they only do side quests! A wholesome show about avoiding the plot
Skyjacks: Courier's Call: (TTRPG, fantasy, adventure, all-ages) In a world of magic, sky pirates, and giant, rideable birds, three teens become apprentices aboard a flying postal ship.
Starfall: (Fantasy, adventure) A runaway swordswoman finds a place to escape her past with a travelling acting troupe, and discovers the literal and metaphorical magic of the theatre.
Stories From Ylemore: (Fantasy, all-ages) In a modern magical world, three kids (a witch, a werewolf, and a curse-bearer) go on adventures together and make a podcast about it.
The Vesta Clinic: (Sci-fi) Patient records from an interspecies walk-in doctor's clinic on the edge of human space.
Wizard Seeking Wizard: (Comedy, fantasy, romance) A dating show for wizards, hosted by a match-mage to pass the time after being trapped in an orb by his apprentice. Every episode, hear from four wizards looking to go on a romance, friendship, rivalry, or collaborator date, and then next episode hear from the two that got paired up about how their date went.
If you like any specific genres of media or are looking for anything specific, let me know! I've played it pretty safe and might be able to tailor some more recs a little better.