I had an advisor for my MA that was great because I was just doing an MA.  He's really good with undergrads and high school students and teaching people the basics and letting them get very good experience.  However, if you're a phd student in his lab, it's really rough.  He micromanages and doesn't let anyone do anything and can be a little condescending and rude if he thinks you're getting ahead of yourself. He's also not great for people's careers - not great about publication, but great about presenting at conferences.  Sometimes, I think he's threatened by the success of his students.   
 
I'm starting a phd program in the fall and my new advisor seems great so far.  He's very available, but laid back, which I like.  I haven't had to actually work with him yet, so I suppose it could change, but so far so good!