I remember reading an interview with RA and he stated that he would "like to act in a film without special effects". He also said that he would like to be in a film in which he is "not fighting or inflicting pain" like he has been in many of his roles. However, I see RA as the next James Bond, after Daniel Craig decides to move on from 007. He has already had practice in acting as a secret agent in Spooks/MI-5 and I think that he would fit the part perfectly. Even if he doesn't become the next 007, he will always be the next 007 to me.
I ran a poll on this site in Dec 2009 - Feb 2010 asking that very question, the results are here.