I have a DRZ400, and I'm very new to it. Getting better all the time, but I'm pretty helpless in sand. We got my wife an XT250, and that thing is a lot of fun to ride. Pretty gutless, but great below 45mph out here in flat land. But it is definitely more approachable and beginner-friendly than the DRZ, and that's saying something. People have asked about road percentage, but the other important question is road speed. If you're ok staying below 55mph, these smaller bikes are great. If you need 65, I'd be considering the heavy pigs. But I wouldn't enjoy one of those on the single track.
If you're like me, and effectively a 40 year old beginner, I'd say avoid the powerful bikes. Everyone on the internet talks about how a DRZ is about as low as you can go power-wise. I'm 240, and haven't found it underpowered yet. Just realize that people always recommend bigger and better equipment than is actually necessary. But what you might need instead is the most approachable stuff you can find. Whatever you get, GET E-START! Nothing worse than trying to kick a finicky two-stroke in an off-camber situation.