I went from crappy 30" Remingtons to 33" BFG a/t, to 33" BFG MTs, to 35" Krawlers in the past 3 years. Krawlers are BY FAR the best trail tire yet. They're fairly tame on road, too, though (& I balance them with soft air pellets only).
Everyone on here is talking up the best TRAIL tires, but honestly, from what you said:
.....I WILL BE DOING MOSTLY STREET DRIVING WITH WEEKEND OFF-ROAD TRIPS.....
For the best bang for your buck ($130-$160 each & 30-40k life span) and great wet, rain, snow, dry pavement, with occasional weekend trips, it's very tough to beat the BFG All Terrain t/a. I know I'm going to take crap for saying that, but if your DD is a part time trail rig, and you don't want to own 2 sets of tires, and you run kids to the school & yourself & your family to the store, work, etc. you know i am right. Also, if national forests, etc. are the extent of your trails, you'll be grateful for them to discuss the trip on the drive home.