It's good.
Not too scary, actually thought it would be gorier, there's a list of CWs here.
It's a game that's a lot about discovering what's there, so I don't want to spoil it upfront. Well drawn, pretty well acted. I finished a playthrough and replayed the end a few different ways, found it fairly satisfying.
Please spoiler discussion of specifics in this thread.
Not very horny at all. The game says "This is a love story" and that's true enough, but it's definitely not that kind of visual novel.