I have a very recent and relevant account.
I myself had never drank into adulthood for basically the exact same reason in not seeing any real point, even mentioned it in some thread before. However, just earlier this month my brother who is a heavy drinker was having his bachelor party and as a fun gift I told him I'd have my first drink at his party since he never really understood why I didn't. So, during the 4 day trip I drank and fully expected to get easily smashed due to zero tolerance.
So, first things first alcohol is mostly disgusting when you have no taste for it. First day I had a Corona (gross) and a rum & coke (semi-gross). The next day I hit really hard for a non-drinker with 3 margaritas (pretty good), 5 mixed fruity rum drinks (REALLY good on the fist one... the next 4 ranged from bad to pretty good, the mix must have been messed up by the bartender) and a can of Pabst Blue Ribbon (Barf). Day after that I had a couple Red Bull + whiskey drinks (average) and what was basically a long island iced tea milkshake (very good, but only because the alcohol taste was completely covered). I also had a glass of very expensive wine on the 2nd day which I wanted to give it's own section because it was one of the worst thing I have ever tasted... just getting it down my throat was a challenge, but my bro's father-in-law's rich friends who got it all commented on how good it is... I think this speaks to the differences of non-drinkers and drinkers pallets.
Here is where I think things go to being less useful, I might need to make a thread about this to query drinkers if it's unusual... but I did not get any kind of effect from the alcohol at all. The first day I only had the two drinks which I thought would do something since it was my first time, but it wasn't too much. The next day is when I drank 3 margaritas, the glass of wine, the 5 rums and the Pabst beer all within a few hours and got nothing from it. At that point it just seemed like reaching an actual drunk state would take excessive amounts so I gave up the next day only drinking the things my bro directly insisted on.
My overall experience, because I didn't even get a buzz, is that it's not worth drinking stuff that tastes pretty bad for no reason. If I wanted to get drunk, the price it would cost in harder stuff would just be too much. So, at least from a similar starting point person I would say you didn't miss out.
Though, if the opportunity comes up I'll try weed at this point just to see if that works and to experience an altered state at least once.