I imagine humor books would be a great fit for situations where people come and go, but I haven’t read much in that genre. Maybe Pratchett would be possible. Generally, a safe bet are older books that are set in a genre that is naturally SFW. I am thinking of Agatha Christie style detective novels.
If you liked the theme of stories in the Name of the Wind, you might like “the starless sea” by Erin Morgernstern. It is a bit “progressive” in the sense, that it contains a little gay love story but all very much SFW and with a romantic perspective. There is one scene however, I’m not quite sure how it was described that could be considered a sex scene? As far as I remember, sex was rather mentioned and not described or anything. Oh, and a big warning, that the sequel of Name of the wind is NFSW. For more fantasy, I can recommend Narnia or His dark Materials by Philip Pullman, which both are series written to be read by children and adults alike.
If you want to continue with sci-fi, maybe consider “We are Legion”/the Bobiverse by Dennis E. Taylor or the Hitchhiker’s Guide to the Galaxy by Douglas Adams.
Maybe check out jamendo.com for listening and downloading CC music