I request it wherever I fly and, as I say, I have never been refused.
Some places do not permit the overhead - Headcorn, probably due to the parachutes, springs to mind in the UK.
Cannot say that I have ever requested it with a dozen airplanes in the circuit but I have done with a couple landing and taking off.
Here is it not an issue as the 747's, Airbuses and even the ATR's and Otters are straight in and straight out and we have less than a handful of light GA airplanes in the country, but we do have a G reg microlight that seems to make the big stuff sit up and take notice when it's flying with them.