Been to Red Cedar many times, but never in the late summer. My buddies and I have have a book full of memories from this lake. The bass fishing is good and there are some pigs to be had. There are tonnes of pike in the usual hammer handle size but two of the biggest pike I've ever seen have been out of this lake.
Wallies have always been hit or miss for us but thats not to suprizing as we never really fish for them except for at Red Cedar. Saying that though we have had good and bad years. There is also many,many good sized perch if your looking for food fish. Not sure how the worms in them will be at this time of year though.
Can't really tell you where to fish as I've never been there this late but good luck and watch out for floating logs if theres a storm!