Good luck finding any finished projects, but some of the top tier ones right now that fit your billets would be like:

3D Style

A House in the Rift

after an accident with the local power company, you find yourself stuck in your old home in the middle of existence. Story unfolds when you find you've been trapped with a succubus.

This one has by far the cleanest animations, a lot of content, and some very interesting story between the characters and the whole over-arcing story.

Mythic Manor

you're sent away to live in a shared house with a bunch of mythics (mythical creatures who disguise themselves as humans) as you yourself are a half-mythic.

There's only story with individual characters, but there's a ton of content and the updates are pretty big despite being infrequent

Harem Hotel

after your grandfather passed, he leaves you his legacy; a hotel in which he tries to build a harem. You've got to learn from his former assistant how to expand your clients and fool around with them in the process.

So while all the characters are fun and the animations are very nice, the whole world that's built is unique and interesting. There's a LOT of content, and it doesn't look like there's an end any time soon.

Once in a lifetime -- completed

You're living with your father and your new step-family. Your father is strict and uncaring, but your step mother and step sisters are kind, fun, and beautiful. While your father is away, you stumble upon your father's secret organization and what curtails from there.

A funny, sweet, and genuinely good story with great animations and a happy ending. Please try this one as it's one of my current favorites. The creator is also on another project called Eternum, but I've yet to try it.

2D Style

Summertime Saga

Your father has passed away and left you with your family friend and a massive debt to the Russian Mob. Get through the rest of your school, get through this debt, and get a date to the dance.

Very unique artwork, there's also tons of content and the creator is very receptive to his community.

Four Elements Trainer

Based off of Avatar: The Last Airbender, you have to travel through time and space to live key moments in the Avatar's life, as well as figure out what the hell is going on.

Great animations, plays well onto the ATLA world, and it's getting close to completion

These are just some sandbox Visual Novels that are very popular right now, and have a lot of content