Snappy, Auto Rotate works for me on the 7D, 1D MK3 and all of the other cameras I have had. I use Breeze Browser, Photoshop Elements as well as DPP and they display properly in each of the programs. I have never used the cable to download from camra to PC. I always pull the card and use a card reader.
Hope this helps.