I wish there was photo management software which catered to non-enterprise multi-user environments.

ie families, or small organizations where the photos (and database) would reside on a computer, but other users on their computers could access it via the local network.

At the moment, this middle ground doesn't seem to exist. It's either single-user only photo management software or full-blown multi-user digital asset management software with enterprise-level pricing.