There's no standard. I draw all my own library symbols, and they end up in whatever orientation was in the particular manufacturer's data sheet. Part of the process for any commercial assembly house is to manually go through and set the orientation (and position) for each part. None have ever complained about the data I give them, nor can I remember anyone ever getting the placement wrong (very occasional human error aside).
I did have an interesting discussion at the Southern Manufacturing show earlier this year, with a vendor trying to sell a simple deskop pick & place machine. Obviously it needs to know the (x,y) position of each part, which I can easily export from my CAD software.
It also needs to know the rotation, and of course, that can't possibly be known in advance, because I don't necessarily know which way round they'll be loaded onto the machine. I've also no intention to go into my library and edit every footprint just for the benefit of one P&P machine.
I asked the seller about this and he became defensive. He was very keen to sell the machine on the basis of its (surprisingly) low cost, but didn't like being asked revealing questions about the time it would take to set up vs the time it would save me doing manual assembly. Plus, of course, it would need a pizza oven adding too, which would have significantly increased the cost of a minimum usable setup.
I walked away. If it's too much work to do with a soldering iron, then it's off to a commercial assembly house.