I have spent quite a bit of time in the seat of Forward-reach forklifts mostly on very, shall we say, "congested" jobsites...
Anyway, they are the best thing since sliced bread, but there are a couple styles you should consider.
The Gradall style is generally rear-wheel steer like a standard forklift. Nice, but limited maneuverability.
I prefer the Skytrak style with 4-wheel steering. It is much more nimble in tight areas. You can crab, pivot or front wheel only.
Most of the smaller Forward-reach forklifts I have run have the 4-wheel steering.
Make sure you check the weight rating at the extension you need, and make sure it gives you some wiggle room. It is interesting to over-reach your load, and pick your rear end up! (it can be useful for getting over muddy ditches sometimes though...)