I really wouldn't consider a CRV for ''off-roading''. I consider it a Civic with a little more space. If you are interested in a Honda SUV, I'd suggest the MDX (under the moniker Acura) or Honda Pilot.
I drove a friend's Pilot, it was very nice. Honda also released a new SUT, check out the news section of this forum.
Welcome!