No amount of money can fix humidity, lack of sunshine, or lack of mountains/ocean and the corresponding activities possible with them (or whatever other natural feature one prefers). Saudi Arabia and UAE can spend all of their natural resource wealth building shiny buildings, but it's still a desert. Also, no one has the amount of wealth needed to stabilize a whole country to make it politically stable and secure.
To be very honest weather is the least of the concerns. Otherwise other cities wouldn't have gatherings of people.
Nobody is saying they should put all the money into turning a developing country in the USA, but maybe they can, I don't know, try other cities around the valley and not get crammed all together into one city that's naturally restricted in growth
Those other cities around the valley are just as NIMBY and impacted as SF is, and the problem is even worse because the local governance structure is fractured. Mountain View, Palo Alto, and Cupertino are all separate cities with their own mayors and councils and zoning restrictions