I think it may be Dangerous Dave in the Haunted Mansion

It's Dangerous Dave in the Haunted Mansion. It's a Romero game from the Softdisk days so there's plenty of gore. There's also unique death portraits for the player based on which monster kills you and those are great as well.

I love the game but if you're a new player just know that it's very unforgiving. Try to kill enemies from as far away as you can and get used to prefiring the green slimes.

https://www.gog.com/game/dangerous_dave_pack