Not sure if someone's linked to this within another thread somewhere already, but ran across this month or two old article while researching image gallery software. The only image gallery I think they list is Gallery2, which is the one I'm already checking out, but it's kind of an interesting resource read. Some I've heard of, some I haven't, some I agree with, some I don't.
Wordpress never excited me, for example.