I live in London and I love the rain & grey skies. I cycle 15 minutes to work, but sometimes take public transport too. I feel plenty productive in this city, and if I were to start my own business, I'd have no problems being here.
I think it really depends on who you are, not where you are.