Yes, I was referring to this old study. Of course it would be nice to see a newer opinion on that, if you know any newer one I'd be interested in reading it. Googling has mainly brought content from the olden blocksize debate tymes (2017/18).
I don't know newer or more reliable of such study. I even asked similar question few years ago on
Are there any benchmark about Bitcoin full node client resource usage?.
I interpret that the UTXO set growth should be lead to even higher memory usage (if higher as estimated back then).
Or slower verification time due to slow disk if owner of the node keep allocating same memory usage.
The compact blocks instead should be mainy being affecting propagation, and not so much verification, because the transactions have to be verified anyway against the UTXO set only once I guess (I don't know if they were verified twice before compact blocks were introduced?).
AFAIK it's mostly about faster propagation.