I've hit everything from early september to early october. it's basically a game of russian roulette. will you get yellow aspens, wildfires or snow? one year i had all 3.
i've often seen different colors in different parts of the park, so you're almost guaranteed to see some good color somewhere. if not, there are some good back roads in the mountains east of the park where you could find some trees further along.