So to answer your question: yes, it changes the experience in a positive way for me and enables me to find fun in games I otherwise would have trouble playing. Your mileage may vary though, and of course I don't encourage anyone to start drinking just to play RE7.
Alcohol is a depressant. That means you should avoid any games likely to stress you out, because the alcohol will make those games worse for you. This means avoiding competitive games where possible, avoiding games where dying is easy and avoiding intense games.