I realize the thread is two years old, but I can put in votes for two freeware applications that I have used with good luck in the past:
Flexible RenamerA little more capable, speaks Regular Expression.
Rename4UA little more accessible.
Haven't used any of the DAM software yet to bulk rename, but these standalone freeware apps are very flexible.
Kevin Forsmo