Its based on where ever you are standing and will only go up or down a maximum of 1 meter.

You can shift click and the hoe will go with what ever the adjacent terrain is. You can combine click with shift click (and the occasional pick strike) to get a more gradual smoothing of the terrain but it takes practice and a single missed click or shift click can mess it all up.