I never bothered reading past the second manga, but from what I can remember, Sister RED was pretty gory...
I think a girl got decapitated, but it's been so long since I've read it.
And agreed with the girl a few posts above; Higurashi is an awesome series.