I believe a number of locals are excited about that. Getting to be that intimately involved in everything the Olympics offers is a unique experience.
That said, if it came here every four years, the novelty would be gone and the harsh realities would set in. It would be great for tourism-related businesses but quality of life for locals would suffer.
Perhaps the Summer Olympics could find a permanent home. I am not sure any one locale would want to perpetually host the Winter Olympics -- outside of those who believe they could build wealth upon it. It would start destroying the very reason you want to live in the mountains.