So I decided to take a go at getting of of them there Visual Novels I've heard about.
I acquired Tsukihime, due to my inherent love of vampires, and finished two of the five heroine's stories (Arcueid (what a name!), and Akiha).
It was basically just stupid fun, with some pretty silly and unbelievable plot points. However, I was not playing for realism, and thus I did not much care about the lack of it.
The graphics were a bit lacking, and since it only used about 5 different poses for each heroine which got cycled around, that was pretty noticeable. But who cares?
I felt that the hentai parts of the game really added nothing to the overall plots.
Also, I might check out the anime if I care to (god, you can say that about pretty much anything from any entertainment media that comes out of Japan).