Hi:
A standard surcharge load would depend on where the wall is, who it is being constructed for, and what it is used for and/or retaining. Many times the owner of the wall may set these values through their design manual if it is a public entity.
In absence of such information, from experience I generally use 250 PSF for a wall surcharge. I have seen this number in a few design manuals by Pile Buck, etc. I use it as a standard for loadings adjacent cofferdams, and have never had an engineer tell me to increase it.
AASHTO uses 2' of fill as a surcharge number to simulate passing traffic loads behind retaining structures (AASHTO 3.20.3), which is also more or less 250 PSF depending on your section of the country.
Personally, I have only used 800 PSF in situations that call for regular heavy loads, such as a marine terminal bulkhead at a port. The Standard Handbook for Civil Engineers (Merritt) gives a range for these loads from 600 to 800 psf, with up to 1000 PSF if justified (For instance, if the pier handles heavy metal ingots).
PEInc above has also covered the other instance where heavy surcharges would be required, which is for retaining structures near railroads. In these instances, the owner of the railroad will ordinarly dictate what surcharge load is to be used. I had a cofferdam several years ago that used the Cooper loading described above. Although I did not actually do that design, I was PM in charge of its constuction and got to witness first hand the effects of such heavy surcharges on construction materials and methods.
Hope this helps.