I agree with you in that the dummy books should not be called that. Maybe change the name to Beginner's Guide to Music Theory would be much better. However regardless of the title those books are very good. I have been through a number of them.
Another way to look at the circle of fifths is to look at it as a way to get back to your tonic chord. For example lets say your first chord is C and the second is B, Using the circle of fifths going counter clockwise your chord progression would be C-B-E-A-D-G-C. Remember the chord progression can be of any version of a chord. For example C-Bm7-E9-A11-Dm7b5-G7-C. In other words they do not have to all be major triads, i.e. major chords. Note that any chord can come after the tonic. Also the above in not written in stone as you can use any chord progression that fits your song and sounds good.
I hope this helps.
Thanks Mario, you just answered
another question before I even asked it. Not only is it musically pleasing to move CW (forward) on the circle, but moving CCW (backward) also works.
I guess one way to really see this in action is to create a BiaB learning tool that spins the wheel in both directions

This is getting better with every post, thanks guys.