I fully agree with you about Sean Connery! James Bond just wasn't James Bond once Connery quit being the Bond.
It's a shame, but boycott Casino Royale. I love the Bond series, but this is a new low.