These are just the Oakmont W/E (30 amp) sites. I walked around in the afternoon to see which driveways had the most shade. I have a pop up so I HAVE to park on the driveway -- tent people wouldn't be limited to that & there's usually SOME tree(s) on every site.
I ranked the sites on shade, proximity to Rocky Beach, and close to restroom/shower.

These are my no shade/minimal (morning) shade sites, to be used as a last resort ONLY: 30, 32,34, 38, 40, 43, 45, 46, 47, 51, 53, 61.

These are my top pick sites (in order): 29, 37, 57, 56, 54, 47, 48, 50, 62, 45, 64, 65.

These are the mostly Afternoon shade only sites in my ranking order: 26, 27, 28, 31, 33, 36, 63, 60, 59, 58, 55, 39, 41, 42.
This was done Aug. 1st so I assume it would apply for most of the summer. The first year we stayed in Rio Frio #474, because I didn't know about asking for OG sites once you got there.
The next 2 years we had sites 31 and 38 (unBEARABLY hot!). This year we had 36 and it was pretty good.
Hope this helps someone else!