an awesome anime,manga and VN (Visual Novel)
and I think you've already guessed it, it is made by Ryuukishi07 (same as Higurashi no Naku Koro ni (Kai)

Mystery vs. Fantasy, great plot, tough riddle(s), closed room murders, crushed faces, blood, unexpected twists etc.

in 1 word:
AWESOME!!!