I've stayed there, managed to get a full-hookup site at the Hickory Hill campground (now $28/night) on a summer holiday weekend by getting to that particular campground loop just as it was being vacated. Hickory Hill is approached from the west on Alameda Avenue from Norman.
Even in the loops with the most "improved" RV sites (concrete pads, FHU, 50-amp) there will be many smaller RV sites, so that a site big enough for your A might take some searching and waiting.
Other CGs with RV pads include Little Axe, approached from the east by 156th street off of I-40 (or from OK-9), Rose Rock Hill and Turkey Pass on the south side, accessed from OK-9 out of Norman.
All of the RV campgrounds are in sight of the water, but to be right on the water you would have to be in a tent area without designated campsites. These are flood control reservoirs with variable levels, and in the state parks they don't put RV sites where they will be under water at flood levels.
AFAIK, there are still no campsite reservations at this state park.
Tom Test
Itasca Spirit 29B