Depends on what you defenition of off road use is
This
or this
For the latter you could use a corrola and it wouldn't matter. For the first one you need to have a decent vehicle but much more important than that is driving skill.
As for the Tahoe. Its the a brilliant car The Vortec V8 has plenty of power. Although you wasted your money on the Offroad package which is local LMS hack job. You could have done better modification at a cheaper price outside.
Our company used the Tahoe for sometime, but Arabian Adventures being the biggest users of it. Its a bit big and heavy in the dunes but once you learn to handle it. Its a capable machine. I doubt your be doing any drifting on top of a high dune edge, but if you wanted to and knew how, you could with the Tahoe.
But keep in mind it doesn't liked to be abused too much, like the old cruisers and patrols