Messing around with updates every few weeks is the single biggest thing pushing me away from Firefox as my default browser. (I do a lot of web development, so I routinely have four or five different ones installed. It's just a question of where I keep my serious bookmarks etc.)
As a web developer, I'm fed up of the moving targets and unreliability. When Firefox pushes an update to everyone and breaks something fundamental, it's not the Firefox support desk that gets complained at when the web apps stop working.
As a user, I see little real advantage from the breakneck pace of development anyway. Inevitably only a few sites use bleeding edge features within weeks of their appearance, and most of them seem to be web design/web development blogs showing off about bleeding edge features that might one day be useful to real web sites.
Moving to silent updates, as done by Chrome, might reduce the hassle, but then we'll also see endless minor UI tweaks happening at apparently random times like Chrome, which is really annoying in itself. And of course if a major bug gets pushed out and breaks a site I care about as a visitor, it's just as annoying whether I manually updated (not that there's much choice if security patches stop for anything more than five minutes old) or it happened silently in the background.
I never recommend Chrome or Firefox with the auto-updates. In fact, we explicitly don't provide customer support for them any more on several projects I work with, that conclusion being reached independently by several different development teams after experiencing all-too-similar problems. If anyone asks, I think the official recommendation in most cases is currently IE9.