I am both pro and con on this one. You have to take into consideration that he not only makes a good impact on RAW but when he is on ECW as well. ECW needs all it can get. You can definitely tell the place is basically turning into the televised developmental ground for WWE, and Bourne has a good place there. He puts on excellent matches with whoever he is up against, but he is very limited to his competition on ECW.
Moving him to RAW permanently would be good for RAW. Mysterio and Bourne make a awesome tag team and they work really well together, and RAW definitely needs more tag teams, but Bourne is a fantastic singles competitor. I think he is perfectly fine where he is as of now, working on both ECW and RAW isn't pressuring him into being on the bigger shows of WWE, but it also give him the chance to work with veterans as well as the newer talent being put on ECW.