We use ours all the time. It is a Paddy-O Shade from Dometic. Cost around $100.00. Camping World, and most other retailers sell them. We use ours often.
Great for shade and OK for privacy. We ask for end of the row sites when possible as we would rather not have someone's sewer discharge next to our picnic table. The shade makes those open end sites a little more private.
One thing we have noticed however is that we tend to have a lot more conversations when the shade is deployed. Other campers are always dropping by to see how it works, ask questions about it and see how difficult it is to set up.
Maybe the privacy thing is all in our mind. I can say we feel more private as it restricts those people that want to walk by and stare but for those that are friendly it almost seems to be an invitation to stop in. Hard to explain, but it works for us.