I'd echo the Blue Ridge Parkway, but I enjoy it even better in the Spring when the rhododendrons are in bloom. For autumn foliage, instead of the ridgelines, I prefer the foothills drives where the colors are more consistent (if you time it right).
I can't pick a favorite, because there are so many more to discover. If the weather is fair, there's no such thing as a bad one, is there?