Winter is ski season, with Red Mountain usually the main reason to visit. Summer and early autumn are best for mountain biking, hiking, and the Seven Summits Trail, which depends on snowmelt and is normally a mid-summer to early-autumn ride.
Spring can be quiet and muddy on the higher trails. Autumn is short but beautiful, especially if you want cooler riding weather and fewer people.