What are the costs like for building resource intensive apps on ethereum? Would be interested in comparing with centralized compute providers.
A lot more expensive. There will be no comparison in cost, or at least that is the wrong comparison to be making.
If that is correct, then ethereum and Amazon spot instances could be interchangeable - low availability, but potentially lower cost due to the bidding process if there is a lot of excess compute power on the network.