Actually, I think it's you that misunderstand. I do photography, and have done plenty of professional studio work.
As to software, I use Photoshop, Aperture, Lightroom, and iPhoto.
And Aperture and iPhoto persist in their single-library single-mindedness, to the point of distraction. Have you shot RAW off a Canon 1DS? Those suckers burn through HD space faster than does a bit-torrent fiend.
As I said, you begin to reach a point where you absolutely, positively need...