Actually, 100 GB BD discs haven been around for a very good while (since the PS3 era which is 15+ years ago°°)... yet, many users still consider it huge, but it was basically a disc standard from very long ago already.
Nowadays... not so long ago... the console manufacturers simply was now "catching up" and the PC market got dragged-along into this new spec as well... on a regular basis (previously it was pretty rare).
Anyway... SSD drives finally are coming down in prices... 2 TB for less than 100 USD... what do you ask for? And HDD prices are steady but the difference is... around 10 years ago you had to pay 300 for a 10 TB drive and now you will get twice the space for the same price.
No need to feel offended... time is moving on and the drives are increasing in size too.
Of course it is never cheap having some private datacenter-management because so many drives involved, but this is another scale which is not a requirement for gaming.
°°Of course the PS3 was using 50 GB discs, yet there was already 100 GB disc available but the drives known as BDXL was simply to expensive for Sony and the industry simply was not ready for it (it would have been a overkill situation). Nowadays the matter has clearly changed.
And nope, it does not really make sense buying a small HDD, unless you get it almost for free and are gonna build a large NAS array... but usually the huge HDDs got a better coins per GB/TB ratio and this is the spec that counts.
Darvond: I know that Call of Duty infamously has uncompressed wave sounds for their pornographically detailed guns. Another area is overdetailing things nobody gives a damn about such as seeing the pores on Skull Face's face or concrete texture #145 (a 2048 x 2048 texture). Or rendering on the fly for camera flaws such as chromatic aberrations, lens flares, and other signs your camera sucks, that no human eye should see.
There are human eyes enjoying all those incredible details, thus even owning a 4k screen and maybe even OLED. It may not be understood by some old school gamers but everything got its place and there is plenty of other games with low details and low data size. If you do not believe me... just look around, it is actually the majority of all games, still.
However, i you want to play a "franchise-blockbuster"... it may be full of non required details and much data size, because this is the stuff a "top notch" gamer using a modern system simply is expecting.
Generally, i am NOT AGAINST something else, because to me everything got its place and what to choce or enjoy very much depends on the individuals; so its great we have all those options available.