Add section on compute resources and provider-specific notes

Please carefully fact check what I've written, I'm not confident that it's all correct (especially the table).  Any provider specific notes you can think of that we should add, please note too (CC @jmontleon).