I've always loved Autumn in video games as well. Here are the two that stand out in my mind:

Tomba-02.png

HoronFall.gif

At my parent's house, whenever I smelled leaves in the autumn, I would think of Horon Village (from the second pic)