You’re not really meant to succeed on some tests, like examining the body, if you manage to do it straight away you skip out a big chunk of the game, but that bit of the game is good, so you shouldn’t skip it! The game is designed around failure as much as success, you don’t need to save scum the rolls, just see what you get and go with it.

You play as an alcoholic wreck, failure is the primary theme of the game and few failures permanently lock you out of content.

yes

Enjoy the failures. They are often better than the success

For me it was a really slow burn.i couldn't get past night 2 because I didn't have money for the room. Did a fresh restart and just got into the groove... It gets better and better and the end is just chefs kiss, the best movie I've acted in kinda feeling..

Do I just need to embrace the game as a simulation of being an incompetent alcoholic jackass?

Yes

But to be real here: If you just can't find yourself enjoying failing in those ways, no matter what you try to do about your mindset, which is fair, you could look into cheating your stats. The saves are editable and there are guides online, and it might give you the opportunity to actually finish a playthrough (and maybe from that on be able to enjoy it "vanilla" in subsequent playthrough to find more stuff).

And lastly, even the worst games will have people enjoying them, and the best ones will have people not being able to get into them. For example, I respect Fromsoft games a heck of a lot, but I couldn't get into any of them at all.

.