There’s lots of different approaches, but I’ve had the same problem.

Steam lets you exclude tags, but they limit how many tags you can exclude so it’s basically a useless feature.

I go to steamDB and it has a ton of sorting options, including being able to exclude “Lovecraftian”, “visual novel”, “dating*”, etc

There’s also a great browser extension for Firefox which is my preferred browser. It enhances the Steam homepage (depending on how you configure it) and lets you do lots of things like quick-sell cards and other stuff.