I manage all my photos in Lightroom. I already back up using Time Machine to a Time Capsule. I'm now going to start to use rsync to back up to my ReadyNAS. I'm also going to use rsync on the ReadyNAS to automate backing up THAT backup to Dreamhost, into my web hierarchy. The gallery is only to keep the backup within letter of Dreamhost's terms of service.
I'll be uploading 130GB of existing images and that's just going to keep increasing. Dreamhost's policy is that your (unlimited) storage space is only to be used to store files that are intended for the web. This is since they actually have limited storage overall and they also back up your web root.
Having the images accessible on the web fulfills that requirement of the TOS and having them linked through a gallery cements it. Plus it does give me some options of sharing some images rather conveniently since they're already on the server and I can set up the gallery to serve specific sizes without actually manually generating anything.
If I just wanted a normal gallery I'd just export directly from Lightroom into any gallery script since they all support JPG.