Really expensive way to drop your day-to-day MPG. Boost kicking in would depend on how the wastegate is tuned, but if you're smooth on the throttle it won't matter. That said, increases the complexity and the heat from the motor: neither are good offroad. Twin turbos are an absolute pain to tune right, too (have you figured out if you want parallel or sequential yet?). Jallen also nailed the high-rev power point: you've got to spin your motor up to have any effect so unless you're going to put some really strong axles in and bounce your way through obstacles east-coast buggy style, it won't do anything for you offroad. If you really have to have forced induction for offroad, a supercharger is a better bet. Much more linear torque and you don't get turbo lag. Also much more expensive.
To be honest, it sounds like you've got googly eyes for buzzwords. Also sounds like your uncle has the right idea. Best bet? Meet up with some of the old grizzled guys at an outing or 4x4 meet and talk just enough to get them started. Then listen. Listen a lot. Ask questions. Lots of them have been there and done that, so they can tell you the effects of NA versus a turbo versus twins versus a super.