very rare, and brief for us
when it would be enough to say it's disturbing those around us started somewhere between 18-24 months! When her vocabulary exploded and her mouth was ahead of her brain. The understanding what NO meant, but not understanding the reasoning was extremely frustrating for her, I often tried a brief explanation, but to no avail.
I think she didn't fuss when she was a baby, in public or at home, because she usually didn't need to. She didn't have colic or a lot of gas, she always had her needs met - sometimes before she knew it needed to be met, I usually carried her in my sling while out in public, so I was already holding her.
Just today, I was at Walmart - the mega center of babies crying alone in shopping carts - mind you it's the day before the Super Bowl of American football, and I live in TEXAS - where football is king......
anyway, we're at Walmart and my husband (who often lovingly teases my parenting ways, but always takes notes) kept noticing how a good 9 of the 10 babies/toddlers screaming were in the shopping cart! At one point he even said, within earshot of this one woman "the kid really would shut up if someone would just hold him" I just kept walking like I didn't hear him... I was sort of embarrased, but he was right! Plus the lady looked like she was the type to turn around and kick someone's butt for "talking smack!" LOL
Sometimes things can't be avoided, kids can feel the pain of teething or any thing can set them off... but overall, I think fussy babies fuss for a reason, and if they're tended to promptly and consistently, you can avoid a scene!