Hello, hello, hello!
I was in that boat once, and I know from personal experience that sometimes it’s really hard to make this first post, so congratulations if that’s the case, if not, then still: Welcome!
If you’re looking for mods for non-fetish games, I’d say the preeminent one on this website is Big Fatties for Starbound. Very, very high quality. Things don’t get curated for nothing!
If you’re looking for some great standalone games, then I would recommend:
Yaffaif - It’s a text adventure game that in my humble opinion is quite good.
Chub, Chomp, Chill - It’s a sim game where it’s kind of like Tomodachi Life except they get fat. I actually haven’t played too much of the versions after 1.0, and me making this post helped me realize I might need to rectify that soon.
If none of these tickle your fancy, then I’d recommend the same thing. Just browse around General Games, Projects, The Curated Projects, and The Gain Jams. There is an endless buffet to feast upon!