Irfanview
Irfanview is an excellent manipulation tool. You haven't mentioned its bulk processing capability, which is what I use it for the most, bulk resizing.
Management-wise I find Windows 7 is fine for me with its built-in tagging options.
I do not wish or need to pay for more complex tools to do these jobs.