I've also seen all the Bond movies, but I think its hard to say who is better at playing the part. Back then, Connery did an amazing job but now a days the scripts have richer content and are better developed. And even though the stunts on Skyfall were pretty damn good, the older movies were bolder as they didn't rely on CGI. I don't remember the movie, but one of them had a jump on a bridge crossing a river where the car spun in mid air, a stuntman actually did that. I'm sure the engineering involved in creating that was extensive, and is something that has been replaced by CGI. I'd really like to see that kind of ingenuity combined with a modern script.