I think Pattinson will be a good Bond. He's got pretty impressive range, and being able to put Twilight behind him and book serious acting roles afterward is a good sign. Ideally I would have liked Richard Madden in the role, or Jack Lowden from the latest crop of prospects, but the studio could have chosen much worse.
As someone who preordered the RPatz A24 Nesting dolls, I also feel he'll be a good Bond.