I went out to lunch a couple months ago with my old roommate who conquered the CPA a couple of years ago. He told me that he was somewhat disappointed because he thought once he passed he would be able to tell girls out at the bar he was a CPA and they would be impressed and that it would assist in picking them up, but that he had found it to have the opposite effect.
While I found it quite amusing when my friend was telling me that story, I think it also speaks to your question to some degree. If you want to be a CPA because you are looking for instant gratification from people outside of the accounting world, then the CPA is most likely not going to give you that. Most of the general public, and even a fair portion of other business professionals who aren't involved in the accounting/finance function, are very uneducated about what a CPA really represents and thus don't have near the respect for it that is probably warranted. (i.e. “oh you are studying for the CPA, I can relate I just got done with my real estate license”)
With all that said if you are looking for respect amongst the accounting community, there is no higher achievement or certification you can achieve period. What doors it opens for you is dependent on so many factors that its really an impossible question to answer (experience, personality, work ethic, communication, timing, location, etc.), but it will always open more doors than would have been open if you didn't have it.
AUD - 2/2013 - Passed!
BEC - 5/2013 - Passed!
FAR - 8/2013 - Passed!
REG - 11/2013 - Passed!
"Do or do not, there is no try." - Yoda