I hear your pain. When my Sony F717 died, I bought an F828, a nice camera all around but really, really bad for macro work. After returning that I bought a Rebel XTI, and haven't looked back since. As an added bonus, my Sony was part of a recall and that works too.
Right now I am working on a series of photography articles for N-Scale. Finding a camera with the right features is part 1.