how can i make a deep hole that does as little complexity as possible
Not sure bout complexity but terrain editor - river bed will make a trench then adjust depth by using RB to select the up/down green axis then use triggers to adjust depth.
Bare in mind though that I think the whole play world has a water level, so deep holes will have water in them.