Starting with 3.1 opencv imread great job with exif orientation. I know this is an old question, but I have been struggling to find the answer to the same question recently, so I post it here. Apparently, cvLoadImage does not correctly handle exif orientation at this time according to an error report on github.
You can find a nice set of sample images with various exif rotations and a good explanation here