For the past 11 years, I traveled all over the world for work averaging 250,000 butt in seat air miles per year. In all that time, I never once used a physical sim purchased locally. I did however use a combination of physical sims (Google FI & T-Mobile) in the early days, and more recently (since iPhone XS) eSims.
I can unequivocally say that the eSim performance and sim performance are exactly the same. If you had issues in Mexico, it wasn't due to eSim technology... rather a carrier issue (your carrier or roaming partners).
With the advent of apps like airalo, international travel has become easier and cheaper! Just got back from a trip to Germany and Italy where I used 2 different eSims from Airalo, and they worked brilliantly. Cheaper than US carrier rates (AT&T, FI, T-Mobile etc) and less latency due to not routing all traffic back to the USA. Not only that, but I didn't have to worry about getting nastygrams from my US carrier about excessive roaming.
Frankly the only time I might be tempted to get a local sim is if for some reason I need a local phone number. However now that nobody under 30 makes phone calls, and everyone over 30 makes them via Whatsapp, Wechat, Telegram, Line, Signal etc... there is no more need for a local# for short-term travel.
eSim is the future, and for anyone who isn't a long-term traveler (>1 month) , there is zero reason to keep the physical sim tray.