The issue for me is that it hasn't moved with the times, so the limitation is getting increasingly out of date. To be honest, I think SQL Server (and Oracle) licensing in general is getting out of date.

Speccing up to 512GB of RAM in a modern server is under £5000. That's small business territory, but you'd have to plump for Enterprise Edition to use it.

Say you wanted to spec out a reasonable 4U server (40 cores, 512GB RAM etc.) it might come to around £25,000. To fully license it for any edition of SQL Server you'd need to spend £180k+ on EE licenses. That's a much higher ratio of hardware->software spend than it was 5-10 years ago.