To Pull the chain (alternatively Catch the chain) in the jargon of inmates is when you get transferred from one place to another, usually on a prison bus (sometimes referred to as a "chain", or "Bluebird express" (in Texas). The context I've heard it used most is when someone gets transferred from a temporary holding place (jail) to where they will do their real time (prison). I get the feeling it has a negative connotation of being forced to go somewhere against one's will and I don't think they use it when they get on the prison bus when they are being transferred for release.
I am not certain of the origin, but from what I've heard and read, it seems to come from the notion of a chain gang. Specifically when a guard wanted to move a bunch of inmates on a chain gang he would pull the chain they were attached to. Another possible (and less nostalgic) explanation is related to the fact that inmates are chained together when they are being transported on the bus.
The metaphor may be slightly different when you are being transferred from jail to prison. At least from the person I heard it from who was going through that process. It seemed more to me like he was likening the transfer to being flushed down a toilet, specifically referring to the old fashioned ones with a raised tank and flush chain. However, it is possible he just didn't know about the other origin and was assuming incorrectly.
Here are a couple of sources online for prison slang:
Prisoner's Dictionary (this is the best one)
The Correctional Officers Guide to Prison Slang
Texas Prison Slang Forum Posting
Thanks to my true-crime obsessed wife, I also can recommend the following book which is more exhaustive and frankly fascinating:
Prison-Ese: A Survivor's Guide to Speaking Prison Slang
You can probably get direct answers from people over at PrisonTalk.com if you have specific questions. It is a support forum for incarcerated people, their families and friends to help them cope with the experience.
Another of my favorites is a euphemism for getting charged with another crime when already in prison/jail. They call that catching a case. I like it because it so vividly demonstrates the mindset of persecution and lack of responsibility that is prevalent among criminals. That is, they get charged with a crime the same way people catch a disease, by being in the wrong place at the wrong time and not because of anything they may have done.
Disclaimer:
This is all second hand knowledge. I've never been to prison or jail personally. I just know a couple of people who have, or have family members currently in prison.
Also, prison slang seems to have regional dialects to some degree. So there might be slightly different terms or connotations in a Texas prison and an Illinois prison.
This is, as you noted, a very American idiomatic phrase which apparently dates from the 1970s. One dictionary includes the phrase in its definition of good, but notes it is American English. An idiom dictionary further refers to the phrase as a cliche. Interestingly, the only idiomatic definition they give is from the McGraw-Hill Dictionary of American Idioms and Phrasal Verbs.
One should be cautious when using this phrase, however. A blog found that the British explanation of the origins of the phrase were:
Have a nice day
Meaning: A salutation, ostensibly to offer good wishes. In fact a banal and insincere form of words given to anyone and everyone. Evidence of the meaninglessness of the sentiment is the fact that it is even used last thing at night when the opportunity to have a nice day has all but disappeared.
Origin: US origin - around 1970s.
The blogger notes that British people may construe this parting phrase as highly sarcastic, so it may be best to keep its use to the American English arena.
Best Answer
It is not about what is common per se but what is correct.
The difference between I have been wanting to go there and I have wanted to go there is that the continuous form of the present perfect focuses on a process, something that has been happening over a recent period of time, while the simple form focuses on the end result of something that happened.
This is better understood with an example.
Present tense in the continuous form, focuses our attention on a series of events that began in the past, continues into the present, and may extend into the future. It is this continuing series of events which is important. Present tense in the simple form, focuses our attention on the current situation or result: that the drinking and alcohol are both finished.
Read this to understand better the usage of present perfect simple and present perfect continuous.