Dragon Age: Origins is pretty gory (for an RPG from that era.) Their whole marketing campaign was basically “look how bloody this game is—even our logo is made out of blood.”
Edit: I would recommend Wildermyth as a whimsical, party-based RPG that doesn’t include stuff like this.
Man, I’m the complete opposite. I find it suffers from the same problem that most of these survivalcraft games do — once you make it past the initial challenge, there isn’t much left to do besides decorate.
I’d really like to see some escalating challenge after you’ve established a base. Progressively difficult raids, bosses to conquer, deeper and darker dungeons. Something of that nature. The temporal storms are a good start, but after a while they become more of a nuisance than an actual threat.
Call of Juarez: Gunslinger
Far Cry series
Wolfenstein: The New Order