One of the features I find most useful is that you can have a window focused without raising it. So if you have some reference material open in a browser over top of part of your terminal, you can switch focus to and even click in the terminal without raising it (in my setup, I alt-click to raise). Admittedly, I'm not sure if this is the default behavior, as many of my settings are non-default.
I also really like the ability to search through window titles. I have alt+/ set to open the window search menu, then I can type a substring of the window title I want to raise, press return, and it's automatically raised and focused.
CWM is really, really nice, and every other WM I've tried before or since has disappointed me by comparison.
Even Windows used to have a powertoy to enable it on Win32.
Exactly how I used fvwm (the original one) and twm back in the 1994 onwards.
To be raised one needs to additionally click on it.
Like you said, it's great to have a small editor or terminal window floating over a web browser, really makes a lot of things easier.