Shay, I can tell you what I know. I know that if I still clung to the romantic belief that I was missing out on the fun, I wouldn't be sober today. Getting sober and recovering is so very hard and I needed to be completely committed to it with no reservations.
Maybe you could try thinking of ways to have fun without alcohol, so that if you are in such a situation again, you would know that there were plenty of sober ways to have fun.