To say cold and cloudy weather is depressing is a personal feeling not a fact. some like the cold. some like clouds and rain.
Also to go there it dont matter as much, its actually more interesting why the weather is like that, with where the island is located and the form of them.
Its all a part of the experiance.
But ofc if you are to summer and sun, there is always the tourist traps of spain and greece and what not.
But I take the cold cloudy weather everyday over a beach filled with sheep.