I'll talk about what I know about Console Connect and the 2D card.
Console Connect lets you use the MIO mixer as a plug-in inside your DAW. I use Logic 8, I just add the plug-in inside Logic and BAM! Then, you just route all of your channels via Firewire. I'm basically using the Metric Halo mixer in zero latency the box is doing all of the work, which isn't the case with the Logic mixer because the program is doing all of the work.
The 2D card with the +DSP license is really cool. There are about 16 different input characters that you can place all over the place to smooth out or dirty up the signal. It looks real good on the sound curves. I absolutely love the transformer character. There are other character models like a tube mics, soft saturation, FETs and a lot of other stuff. You can run all of this straight into Logic.
I haven't used any of the older versions of the Metric Halo stuff, but this thing is great for what it does and the cost.