Dell is still selling servers, with 8GB of RAM. I don't think any window has closed even on the 8GB.The problem is that in 2024 it should be standard. In fact, the window for 16gb being standard started to close years ago.
I see lots of systems being sold with 4GB for Windows with a 128GB cheap SSD. People still buy them so there is a market that is being satisfied. You cannot get much done on 4GB, but the buyer can do email, web, financial software, some picture editing, video phone calls. For some that is enough.
Those are doing more, probably know they need more memory and storage and pay for it. Apple is not unique in their prices for additional memory. The Surface line of products from Microsoft upgrades are just as costly.
Truth is no one here knows about the real cost. The chip yield on the larger chips may be much lower, thus costing more than the lower values. There may be some chip logistics that require more real estate thus lowering the chip yield per chip wafer. To compare Apple's memory to some memory stick from Crucial is not comparing the same items.
Look at the prices on Dell's website for the cost of upgrades. Their systems start with 16GB because the systems are running Windows.
Apple is not doing anything the industry is not doing. Comparing desktop memory to laptop memory is not a good comparison.