1. How well does the 2nd Gen Xterra do off road? I'm not talking about hard core, but trails about on the level of Shafer Trail in Moab, Saints John/Radical Hill/Red Cone in CO, etc (basically 4 on the 1-10 scale used in Trail Damage.) I can't speak for those trails, but I can say that I was very impressed with what mine could do off road. The rear locker and the low range make it very solid off road. If you put some sliders and upgraded skids on it, along with a minor lift, you should be able to get all sorts of fun places.
2. What kind of real world MPG are you getting with the V6/auto combo? My research indicates the X has about a 21.5 gallon tank, what kind of range are you getting out of that? 19.5 in the city, 17 on the highway in the Appalachian Mts. In the winter that drops due to the winter-blend gas, but it's respectable for a 5K SUV.
3. What size tires are people running without modification? Right now I'm running 235/85/16 on stock wheels on my Taco and they are tight but they fit. I'd like to run a similar size tire since it seems to work well for me. 265/75/16 are stock, might be able to get 285s on it without a mod. Might. However, the 2" SL will make sure I can.
4. Is the X big enough to sleep in? The photos I've seen show a pretty flat load deck, so that's a plus. I'm 6'1" so I'd want at least that much space. If you get a set up like Mosi's, absolutely. I'm 5'11" and with that I'll have plenty of room.
5. Any known weak points? Engine/transmission/T-case/axles? I've heard something about weak or fragile axles but if that's only when doing hard-core rock crawling, it's not something I need to worry about. How well does the electric T-case shifter work? I'm leery of those but OTOH my wife's GV has that and it seems to work just fine (of course, her GV is full time 4wd so it's not like we have to shift it at all during normal driving.) I think the later 2nds have changed something with the front axle as I've not heard of anyone blowing it up on the later ones. Keep up with the lubrication PM and you should be fine.
6. How noisy is it? My Taco is a fairly noisy vehicle so as long as it's not noisier than that, I won't even notice. I wouldn't say it's that noisy with the windows up. Never been problematic for me.
7. Bottom line, if you knew then what you know now, would you get another X? In a heartbeat. If I was in a wreck tomorrow and totaled it, I'd have another on order immediately.
Side note - my 2nd post here and in both I'm pimping my Xterra. Both times to the same guy. Maybe I need to get a life...