I like this Tool, because focuses on the organization of your pictures (and videos). You can easily manage and apply new keywords. And you could create smart albums/collections based on different filters. It's not bloated with picture editing stuff, which I personally do not need.

I have been using FotoAlbum for years, so my opinion is certainly biased. I tried to do a quick comparison between FotoAlbum, Phototheca and JetPhoto. I confess I have been unable to use JetPhoto, so that I have no opinion about it apart from the point that the first steps are less than obvious to me. Phototheca and FotoAlbum are close: free and paid versions, both use a library to which you must first import your images... The advantages of Phototheca are cosmetic, but cosmetics are important for photos! I don't know why, but all FotoAlbum themes are light, and I prefer a dark background to see my photos. Apart from that, I feel that FotoAlbum has much more features than Phototheca in the free versions, especially in the tagging features, but also in the fields which can be used to create a smart album. This is not an in depth analysis, as I did not create a comprehensive list of features to compare these softwares.

[Edited by davitof, August 07]