Taking a brief look at Airalo, it looks like it'd cost me $4-5 per gigabyte to buy an eSIM. I literally see no unlimited options on Amazon.
Randomly navigating to telekom.de, I see a front page offer of €34.95 monthly for a five gigabyte plan with a 24 month contract term.
Unlimited plans usually throttle you these days too. I have €60 “unlimited” from orange.lu and after 250GB it throttles to 250kbps. At this speed hacker news is usable but not much else is. It’s €20 to add another 100GB. While waiting months for home internet to be installed I tethered to this and between WFH, gaming and streaming I usually had to top up 1-2 times per month.
I have always thought it a bit odd that users with a monthly contract often pay more than "pay as you go pre-pay" but I think that is because it is mainly business and older people who opt for a monthly contract.
I think there are unlimited or huge (30GB/month) sims available for non-tourists. A lot of households use 4G as their main internet source via a dongle!
There are many options for non-tourists.