Frustrated with the epic suckiness of Gallery2 photo album.
Looked into Zenphoto, and it seemed like a great solution. Sadly, Eye-Fi does not support directly uploading pics to it, which is something I can no longer live without. It doesn't take long at all to get used to your pictures magically showing up online; manually transferring them from my camera to computer to internet makes me feel like Elijah Wood in <i>Back to the Future II</i>. ("You have to use your HANDS? It's like a BABY's toy!")
Being a total nerd, I quickly thought up a solution to this problem. After photos upload to Gallery2 they live in a specific directory on the server. Albums are even sub-directories within said directory. Zenphoto can monitor a directory for new photos, pulling albums from subdirectories. SO, my solution was to use Gallery2's directory as Zenphoto's 'incoming' directory. Now when I turn on my camera within range of my Wi-Fi, it uploads them to my Gallery2 installation, and then the photos magically show up in my Zenphoto installation as well. Sadly Zenphoto is much more limited in the things it can do and thus is not the magical-happyland solution I was expecting, leaving me with two concurrent sub-par photo albums. But at least they're in sync, so if one of them becomes less sucky at some point it will be easy enough to pick it over the other.
For those who want to see the difference, <a href="http://pics.nyquil.org">pics.nyquil.org</a> is the Gallery2 version, while <a href="http://photos.nyquil.org">photos.nyquil.org</a> is Zenphoto.