Actually, no it isn't and at scale it makes it even more expensive, because you need redundancy. We are talking about RAID and CDN, not to mention that at scale hardware breaks a lot more often.
What actually makes it palatable for businesses such as Yahoo or Google is that many people pay for this storage without using it, while heavy users that share a lot help by marketing the product through their sharing to others.
On the other hand I've got 50 GB worth of data uploaded on Flickr. You can't tell me that 50 GB of redundant on-demand storage is worth $25 / year, unless you live in some kind of fairy land. I also have only a couple of photos shared. So what value does Flickr get from me?