As a huge Bond fan, I quite liked this article, and have a lot of opinions on the subject. I pretty much agree with your ratings, though I want to point out that Valentin, the Russian smuggler, was a strong recurring character and gave us the best moment in "The World is not Enough." There was so much potential in that movie, and it breaks my heart that it sucked so much. Also, despite the buzz that Berry got for role, I think it goes without saying that Michelle Yeoh was much better and would make a far more interesting and watchable character were they ever to bring a Bond Girl back or spin one off into her own series.
As for new Bonds, Clive Owen is the obvious one, but I could see Gruffud doing something interesting with the role. Mcmahon has been wretched in everything I've ever seen him in. Mcgregor is awesome, but I'm not sure I can see him as Bond, and Grant I just...I can't see it working. He's never played a character that didn't evoke a puppy dog at some point, with his stammering and bumbling and fawning, and I doubt he has the range to turn that around into a good Bond. Ledger is an intriguing suggestion, and I could probably be convinced.
My favorite suggestion, however, is not on your list: Christopher Walken. He would be older, yes, and the accent would either be gone or terrible, but just imagine him in the role--he could do everything Bond needs to do, and he'd do it with a perfect mix of style, wit, and underlying danger. Bond is a man who kills people for a living, often casually, and often accompanied by heartless one-liners--Walken could bring out the darker undercurrents of that character in a remarkable way.