Shameless plug for an app that I've been working on... It's called Ringleader. It is basically a ringtone manager that will let you manage all of your phone's ringtones via one ringtone manager screen. You can define multiple profiles and have different ringtones for each profile. I have also included a widget and a Tasker plugin on the Pro version. If you search the market for "Ringleader", you should be able to find it.
Let me know what you think!