My counselor was great. I could go in at any point (as long as he wasn't busy) and just talk with him. He reviewed all my applications, gave suggestions about which colleges I would like, etc. Of course, I went to a small private school.
The deplorable college counselor system is one of the main reasons that public schools suck.