It's very annoying indeed, units should get as close as possible to their target destination, and stop only when the path is completly blocked by other units.
The pathfinder could get some ergonomy improvement. Also, when you want to cancel a movement, in previous Civs, you just had to press...