Whats the deal with counter-rotating props?

Hello,

We're looking into a twin and the Twin Comanche is on our list. I know
that the later models have the counter rotating props -- although i
don't know too much about what this means, other than its "better".

We fly a mooney now and thus I don't worry about the prop -- as long as
it keeps spinning.

Is there a web site that gives a good explanation as to why I want CR
props. There are hundreds of the earlier model Twin Comanches flying
without the CR props --- so what does someone with 300 hours single
engine time need to worry about? What actually goes wrong? And when
it does, what happens? I hear "critical engine" but it means very
little to me.

I like to fly and try to be very careful when I do fly... but I don't
follow too much aviation stuff other than how it affects me -- so I'm
not exactly a "buff", hence the above questions which may seem obvious
to many.

Why are we looking at a Twin Comanche? Because its a twin, safer for
IFR flight (perhaps this is only preceived), plus we live on the east
coast on an island so we're flying over water quite a bit. Also this
plane has decent speed and is an "economical" twin. We rarely fly with
4 people, so we don't need any more seats than 4.

Any help or links to help would be appreciated.

Thanks,

Dico