eSIM kind of solves this issue to a degree. However it’s up to network provider not to suck. In my country when you buy eSIM you get it on a folded cardboard which contains qr code. If am nit mistaken you can buy them on kiosks as well. So they work every bit as well as regular sim. Problem arises if you phone doesn’t have regular Sim and country you are visiting doesn’t have eSIM.

Then again this has fewer issues in EU due to no roaming charges.