This is a really interesting topic! I'm a fan of boyband Take That (you probably only know of them if you're British!) and I moderate on their official forum, and we have lots os similar debates going on there.
It's a difficult one because on the one hand Rob does tend to look very uncomfortable at the big events with thousands of screaming girls, and thats a shame. But on the other, his chosen profession is to be an actor in Hollwood movies & everyone knows that some level of attention is to be expected in that.
It's my opinion that he is just a little overwhelmed and maybe thinks he is not worthy of such attention, and that humble attitude is very refreshing. It seems to me that the madness only occurs at promotional events where there are a concentrated amount of Twilight fans at once....and this is what the promoters of the movie want! I suspect that his everyday life hasn't been overly affected and he can still go about his business as usual (I even think I've heard him say something to this effect in interviews).
As soon as the Twilight mania dies down and all the movies have done what they need to, he will still have a following but it won't be as manic and he can maybe be more choosy with his future roles. He won't always be 'Edward Cullen' & while he is it's doing good business for the movie franchise and him (lets not forget he is going home with a big old paycheck at the end of the day!).
All told, I don't think life is too bad for Robert Pattinson