To those that 'play' Adult VNs on Steam, looking for some recommendations.

A kiss for the petals is pretty lighthearted if you don't mind yuri themed VNs. The same goes for most of the Sakura games, they are quite fun, don't take themselves too seriously and the narratives are mostly good. There are a lot of them to choose from, but from the ones I've played, Sakura Sadist and Sakura MMO 2 are my favorites. Just remember to get the 18+ patches, it's very simple and you'll find how to do that in the game's guides.

F95Zone is a big community site for adult VNs .. might help better with recommendations
The amount of adult VNs on Steam is barely a tiny slice of what is available there.

these are the best: Lust theory , Chasing Sunsets , Summer's Gone , College Kings , Being a Dik and Where it all began

I think the Monster Prom games would be perfect :) I also have these on my to play list:

Purrfect Date
Aviary Attorney
Purrgatory
Raptor Boyfriend
The Murder of Sonic the Hedgehog
Wintermoor Tactics Club

They aren't really "Adult" but they are fun and goofy!

This is a complex question, because it depends of a particular taste. Example:

Adult VN with 3D characters with more porn and interaction: Lust Academy
Adult VN with 2D characters: Summer Memories
VN without adult content: Phoenix Wright: Ace Attorney Trilogy

Free:
Adult VN with 3D Characters: College Kings
Adult VN free not on Steam: Katawa Shoujo (I really liked this one)

Not sure whether you are looking for an adult VN or a sex game like the House Party you mentioned; well maybe both, but I would highly recommend https://store.steampowered.com/app/560000/Ladykiller_in_a_Bind/
Its def not catered towards men and ohh boi I just reread the description after many many years and it sounds like straight up anime. :D

https://store.steampowered.com/app/1775530/Artemis_Book_One/

best

Edit: okay to give a little more context most or pretty much all the other recommendations here aren't funny or goofy but Artemis isn't only super high quality and has a good story but it is also very funny at times

this is pretty good - https://store.steampowered.com/app/1582890/My_Catgirl_Maid_Thinks_She_Runs_the_Place/

Highway Blossoms is really good and wholesome.

Not exactly an adult VN but I think a woman would enjoy this. Very cute story though translation might not be great.
Cross Princess