I think it totally depends on the rooster. A good rooster is an asset to his flock. The flock dynamics work better, he breaks up hen fights before there is blood drawn, he shows his hens where the goodies are, he will round them up and get them under cover if he sees a predator (although I have lost many, many hens to predators and have never lost even one rooster, so I don't think most roosters will sacrifice themselves for their hens). You will also have fertile eggs to put under a broody or in an incubator if you need replacements.
A bad rooster will make everything more stressful for everyone. He'll rape the chickens (mounting by force, not dancing for them, spurring them or pulling feathers) and/or he will attack you, which wrecks your enjoyment in your flock. Since these behaviors have a genetic component, you won't want to hatch eggs from him because you won't want to perpetuate these behaviors in your flock. Also, a rooster can be hard on your hens' feathers, and you may start seeing bald patches just in front of the tails of his favorites. The hens don't care, but often their owners do.
I like having roosters, and usually keep 3-4 in my flock. But I don't tolerate any aggressiveness whatsoever. The first time a rooster tries to intimidate me (coming up to me with his head lowered and his feathers fluffed up) I squawk and shout and chase him all over the pasture, and if I can catch him, I pin him down to the ground until he stops struggling. That usually does the trick for the rooster who's just seeing if I can be intimidated into letting him be the alpha roo. But if a rooster comes after me a second time, he's culled that very day.
I would also recommend no trying to tame your rooster. Let him be a bit intimidated by you. Make sure he moves away from you when you walk towards him. Minimal handling will accomplish this. When you pick up and pet a rooster, you are telling him in chicken language that he's higher in the pecking order than you--subordinate birds groom the alpha bird, and the alpha bird has the highest perch. So tame your hens if you'd like, but let that rooster know that you are the boss.
My roosters come running when I call the flock, but move away from me if I move towards them. This is a show of respect towards me, and just right.
I also watch his behavior towards the hens. I only have one rooster right now (lots of cockerels, but they're not in the main flock yet) and I'm thinking of culling him. He's just not great, and he doesn't dance for the hens--just mates them. Poor girls are losing feathers at the back of their heads, not just above the tail, since he grabs the backs of their heads to hold them still for mating. So although he is a reasonably good rooster, I keep giving him the side-eye trying to decide what to do with him even though he's never shown any aggression towards humans.
Roosters are advanced chicken keeping. I would always recommend a person get at least a year of chicken keeping under their belt before getting one.