Imagine somebody that wants to get the features of EC2 and the features of BigQuery or some of Googles ML stuff.

I suppose. The downsides seem large enough that I would try and find alternative implementations such that I could do it in one cloud. Or ar least something that highly minimized cross provider dependencies and expensive data xfer.

You're fighting the purpose built intention of the cloud to make it costly and clunky to move data out.