The reason I don't use cloud computing is that you constantly have to worry about moving data around, turning stuff on and off, API changes, data movement costs, product lineup changes (should I store this stuff on S3 or local HD), locally compiling all your stuff again or containerization and associated time overhead.
Local large box makes way more sense if you're doing solo projects. And if traveling, it would way more sense to rent a VPS from Hetzner. Flat cost structure and tons of bang for the buck.
BTW, I you can get 128 gb LGA2011-v3 motherboards.
https://www.newegg.com/Product/Product.aspx?Item=N82E1681315...
and it seems like it works: http://www.pcworld.com/article/2938855/hardcore-hardware-we-...
even though the spec says max 64gb: https://ark.intel.com/products/82932/Intel-Core-i7-5820K-Pro...
Disclosure: I work on Google Cloud,