Through various settings, you can make it as light or heavy as you want to these days. Min relay fees, blocks only, max connections. With 500GB you don't need to, but pruned nodes will become more popular too.
I think in the future, the bitcoin full nodes will have different targets. Some of the full nodes are mining nodes, which will have very fast CPU and large RAM, SSD and high bandwith; Other full nodes are just fine with store the full blockchain data, but they can accept some delay in the update of the blockchain data for like 10 to 15 seconds. So this kind of storage nodes, which has low RAM but large HDD disk, can act as full node for a very long time, at very low cost. There is no need to worry about increase the block size, hence increase the total block size data to 100GB level.