The point of no return on a night out

This all makes sense in my head, so bear with me.

On a night out, I’ll be drinking and having fun, maybe go to a few bars or a club. But, there will usually come a point where I feel a bit sick. Straight away, i’ll drink a decent amount of water and head outside just to calm down and collect myself and i’ll feel better within 5-10 minutes. However, after this there is really no going back for me mood wise, I won’t want to drink any more and i’ll want to go home.

I feel like I’m limiting myself a bit since i’m still young and my friends can all keep going even if they’ve puked in the bathroom. Is there any explanation for this or am I just being silly and should listen to my body?