There's SO much I could say on this topic...but I have too much work to do tonight. Short form:
After the first hour I experimented with the Console Emulator, I figured I'd never use it again. Then I saw the comment about inserting it in every channel FIRST, and mixing through it. I tried that, and thought it had promise.
Then I ran some tests to find out exactly what it was doing. That helped me figure out how to apply it better. More importantly, Quick Group is your friend with the CE. It lets you bypass/enable all of them at once, as well as adjust the trim and drive controls simultaneously.
I wrote my next Sonar column on the CE. The first third is about how consoles affected the sound, why that mattered, and why you might want to emulate some elements of it. In particular, the CEs emulate some of the characteristics of transformers. One of the very few instances where I use the CE NOT as intended is as an effect on bass with the S-type module to emphasize the transformer emulation aspects.
I currently have two songs posted on my YouTube channel
(subscribe! share the links! 
) that use the CE extensively. One is called
"When the Grid Goes Down" and the other is called
"Little Pieces." I also posted an
A-B comparison with the CE bypassed and enabled as it plays an excerpt of "When the Grid Goes Down." The alteration is subtle, but definitely audible.
Bottom line: I was raised during a time when the Aphex Aural Exciter was rented out
by the hour. The CE accomplishes the same sort of thing from a conceptual standpoint - it can add an extra 5% of coolness to a piece of music when applied properly.