I liked the rural feel, while I was there - there's more than enough to do on campus that it was nice and peaceful. But that's more of a personal preference. If you absolutely MUST shop every day... probably not the best place. But it's not terrifyingly boring, like it might sound from the description of the locale, most of the time people are incredibly busy.
I never had much of a problem with class registration - from what I could tell, it's usually better than a lot of other schools (you don't have to run all over campus signing up, or sign up for 8 classes at the start, go to all of them, then figure out which to take, and for popular departments, majors get first choice), though it's certainly quite annoying when you're a first-year at the end of the registration list, of course.
In my experience, the dating scene can vary by your group - I can think of 5 long-term Colgate couples that I'm friends with off the top of my head (who are still dating a year or two after graduation!) plus two or three more still at Colgate, so it's certainly not impossible, but it might be hard to find. The "main" scene is definitely hook-ups, but if that's not for you, it's not a huge deal. Like with drinking, there doesn't seem to be much, if any, peer pressure. If you're not into hooking up or getting trashed, it's not a big deal.
My least favorite thing is that it's FAR from my hometown (Seattle). It's actually faster to get from Seattle to Japan than to Colgate's campus! It's worth it when you get there though.