Are you looking for an organized tour, or one you can drive on yourself?
There are actually Gravenstein apples are actually in season right now, and there are many U-pick farms where you can go and pick your own. For the most variety in apples the best time to go is generally anytime in October. (This is usually when I stock up on my own to make apple butter.) See the Hood River Fruit Loop for detailed information.
For best fall colors, I suggest a drive along the Historic Columbia River Highway. The combination of waterfalls and autumn foliage is outstanding! This can also be done on your way to Hood River to fetch apples!