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!