Great for advanced people who use Windows or OS X and want to pay money.
There's also a few good open source options in this direction for people on Linux.
The problem is Picasa was so easy I could give it to an average user and have them pick it up quickly and enjoy their photos. I can't think of anything nearly as dead simple.
How do I scroll through my entire photo collection in Lightroom with it keeping my folder tree in sync as I scroll and dividers by folder so I distinguish between groups of photos?
As far I can tell in Lightroom my old options are (1) show all photos from all folders in one giant grid so I can't tell where one folder starts and another ends nor can I tell which set of photos I'm currently looking at. Or (2) only view one folder at a time