This, IMO, is one of the good examples of "If you want it done right, you've got to do it yourself".

As a both digital and film user, I tried really hard, but couldn't find an application that would do what I want. So I just do it all myself and use the Bridge for previewing and batch operations.

I settled on a very simple method - I name each folder as eventname_yymmdd (some times I would omit the dd part) and then name the images within as eventname_yymmdd_serno. Tools built into the Bridge make the renaming really easy - one step process most of the time. From there, it is a simple matter of keeping them all in one place and having regular (multiple!) backups, but that's another topic.