I loved Casino Royale. It's the best Bond film in ages. I agree that Die Another Day was almost a parody and that we needed something more intense.
My only criticism is that I honestly don't think the first hour is that good. It's alright, but nothing special. Once Vesper is introduced on the train however, the rest of the movie is near perfect.
I am very excited for this one. I have to say Sean Connery is likely to stay my favorite Bond. I think those 60's movies really hit the perfect tone.