Cloud provider's best trick was to convince everyone that network calls are better than function calls.

Not really. Cloud providers did convince everyone that if you hit a resource limit in one of your boxes then your best strategy is being able to add more boxes, and not move everything and the kitchen sink to a larger box.

Also, not everything sits in the hot path of anything. Sometimes all you want is a long-running job to run somewhere.