In a nutshell, the access is questionable if not illegal (it's changed a bit in the last few years), it is shallow at lower levels and deeper at higher levels (not sure what those levels are), at the highest flows I've seen it's a sweet green wave but tricky to get on, I don't think it's ever very sticky and there is a huge pool behind it, nice wave/hole at normal levels. Usually not like South Canyon, but can be at higher levels.
The backstory... around 1998 or 1999 three 16/17 year olds drove to Plateau Creek one afternoon (as they had all week), and did a little park and play at the tail end of a temporary culvert. Turns out the contractor that placed the culvert was a bit unhappy that we were cartwheeling the shit out of that feature (and we were a bit unhappy that we couldn't play in Plateau Creek even though he could pipe the entire flow), and the contractor kicked us out. If we weren't in high school we might have argued more, but instead, we packed up and drove to the cameo dam for some weird reason. We could see the flow in the 7th gate (at that time, it's now the 6th gate due to the fish ladder in the 1st gate), and decided to gear up and paddle over. That day was the best flows I have seen on it, and we were surfing 3 across on a big green glassy wave. The rest of my visits have provided a smaller wave/hole feature, and always fun.