Yes, often dogs will lose their minds, and still do what they want - especially if there's food involved - but you only have to look at them a certain way, or use a particular tone of voice, and they'll slink off to their bed with their ears plastered against their head.
I used to own a lurcher called Finn, who was the most neurotic animal I've ever known. He seemed to exist in a constant state of neediness, always looking to me for reassurance, as if he was worried that he'd done something wrong. His almost constant anxiety-induced flatulence was something I'd never want to inflict on another human being.
Nonetheless, I love a bit of neediness, so consequently I loved Finn, and I'm very much a dog person. Unfortunately, I also really hate faeces. Call me weird if you must, but I hate picking it up, I hate smelling it, and I hate treading in it. If you're a dog owner, these three things are unavoidable.
It's different with cats. I get absolutely no love from either of mine, let alone acknowledgment that I even exist most of the time (unless it's time for them to be fed). But at least they do all their shitting in next door's kid's sandpit.