As with most things, I think the answer is “it depends.” I have seen some very efficient storage systems designed around S3/R2 object storage where applications run in ephemeral containers, and storage is abstracted.
I have also played a role in running an on-prem SAN that worked well mostly.
I have also played a role in running an on-prem SAN that worked well mostly.