for stills or even DVD-quality video, if the cost and the features tickle your fancy, I see no problem with the Drobo, really. Still seems a bit costly to me for not being at least GB ethernet interface directly (not USB mediated), but you're paying for essentially zero user setup and a fair amount of redundancy built in. You could likely also build your own NAS block with FreeNAS or whatever, build a computer with big drives using Windows Home Server to add to your personal network, buy a Buffalo Terastation, or for that matter just buy a single reasonably fast SATA disk and put it in an external eSATA enclosure, plug it into your editing workstation, and leave it turned 'off' when not in use as at least a modestly trustable backup (still single-point failure, but it shouldn't fail when it ain't on if you don't play football with it, or keep a coffee cup on top of it to tempt fate). The real question is what are you after: inviolable backup or additional live storage? The demands of each are different, anywhere outside the corporate IT backbone level. Anything that tries to be both on the cheap will inevitably suffer the Law of Multifunction Devices: the more functions a given device is designed to address, the less perfectly it will perform all those functions. Or 'compromises happen', for short.
As to the Law of Multifunction Devices, I hear that. TVs with DVD Players and VCRs in them?
Basically I was kicking the Drobro thought around for some storage that is self maintaining/reliable for bulk storage of items that I will access from time to time that is easy to get to. The USB was a no-go, but FW800 made it appealing for some uses.
I have eSATA drives, such as the SeriTek 5 Bay, Wiebetechs RTXs and Macs networked via Ethernet. I do back-ups (including moving things offsite as needed) and would never suggest that anything should replace that. But some things can get moved to storage where I do not need the speed or full blown "safe" back-ups but would otherwise like the convienence of access. For instance - builds of DVD Projects. Having them somewhere where they have a bit of safety (as oppossed to just being on a single drive) while not tying up space/bandwidth for more important things has an appeal to me. Same thing for items such as audio files with Logic, Soundtrack or Garageband. Amazing how quickly terrabytes fill up nowadays when everything used to get on a Jaz Drive
It could be Drobo or something else.
It may be worthwhile for some things, afford a bit of protection, looks fairly simple, takes care of itself and could be something that people who may not be inclined to set up things such as RAIDs or do not get into good back up plans. And if it is in fact quiet like they claim that is a big point for me. There are posts around here where people have things on just one drive and run into issues or are looking for back-up storage (or more often just larger storage) and they appear to have all their eggs in one basket. The Drobo could be a better basket, although not perfect.
For things such as photos, DV and HDV the speed should be enough (subject to multi-streams and huge RAW files from some of these new cameras
) So that is why it re-caught my eye as something that could be a good add-on for general use with some levels of saftey, albeit at a slightly higher cost than other things and also subject to the potential limitations in the technology, and limitations in design as to what should be achieved and other issues of "points of failure" as both you and Craig pointed out.
Like I said I was considering one myself once they introduced the FW800 and mentioned that the feature was here.
Now I will in all likelihood HAVE to get one since you and Craig have provided so much good information and someone needs to get their hands on one and report back on how it goes just so everyone knows one way or the other.
Yes, you are both now officially considered enablers and I would appreciate you both coming into any thread I start called "Considering buying a ________". 
Kidding aside if I do get one of these I will post back and let you know how it goes.