Do you like movies/games with over-the-top gore or you consider anything like this downright juvenile, unless it doesn't treat itself seriously?

It really depends on how earnest the overall game/movie is, whether the story is serious or just a mindless action tromp: if it's over-the-top but it feels forced "kewlness", or if it's meant to be a part of the drama but the story/characterization goes for cheap (or "deep") shock value over genuine effort, then it's a bad, juvenile thing for me. Inversely, if the over-the-top is genuinely cool/impressive or the overall drama/characterization is involving enough, then I don't mind it at all.