I think Vancouver is at its best in Springtime. Right now there is still snow on the mountains, the flowering cherry trees (incredible at this moment!) are beautiful, and there aren't too many tourists around yet. The last two weeks of August are traditionally wet (yes, it rains often in Vancouver, but if you want real summer weather for your trip, then the last two weeks of July and first two weeks of August are the sunniest.) We have just had the coldest April on record and a snow pack about 40% higher than normal means we could be looking at flooding in some areas when it finally warms up. Trees turn colour in late September into October, days can be mellow and lovely, and again the tourists have gone by now. Unless you are a skier, November to end of February are probably the least enchanting months with rain or snow and grey clouds prevailing.
So you want just one month in 2011?? Well, June or September weather and prices may be the most attractive.