Is any camp site really bad? It's always great to get outdoors!

I haven't been in several years but I remember that I loved these sites do to easy access to the lake. My only complaint is that the lake gets crowded with motor boats toward mid day. This makes the water choppy and difficult for kayaking and other sports.