Cakewalk comes with a lot of cool effects. I don't know how extensible the effects are though. If it is able to take plugins that's a good thing.

The others probably have cool effects too. CoolEdit has reverb for sure, though I like Cakewalk's better... uhhhh... I think Steinburg's program has plugin effects that are supposed to be really good.