I agree with mid that whatever the developer thinks is necessary to convey the message is good.
Different people can have very different tolerance to horror/violence/gore. I make only horror games and each of my game has received feedback ranging from the game being "too scary" to "not scary at all." It is very hard to determine if a game has gone "too far," and I think game creators should just make whatever they like.