The "best" tire for 95% pavement/5% off road probably is the Michelin LTX M/S2. It's got top honors in the tirerack.com survey, and if it's better than the LTX M/S, it's no wonder why. It might not be considered aggressive looking, but the classic four channel design and sipes is all it needs to provide traction in the dry, wet, and even in deep snow and off road in dirt and mud. If they ever make them in an LT variety when the originals are completely discontinued, I'll be going to those. The great thing about the Michelins is they last a long, long time. They only have a 60,000 mile warranty, but they tend to last for 80,000-100,000 or more. My last set was barely half worn at 60,000 miles, and that was even with some alignment issues and without regular rotation.
Michelin also has a $70 instant rebate offer, so if you buy 4 of these at an authorized dealer, you get $70 off.
If you care that much about looks, the BFG Rugged Terrain is for you. It's in second place at tirerack, and though it's fairly new, it's perfect for those who want a good pavement tire, but with cosmetic elements to go with the looks of a pickup or SUV. The other thing that's great about it is the price. The treadwear rating and 50,000 mile warranty makes me think it won't last nearly as long as the Michelin, but if you like the looks more, the lower price helps and they should be good all around otherwise.
The Firestone Destination A/T and Michelin LTX AT2 are good all-terrain options, but those are more for vehicles that see more than occasional off-road use. I know all-terrains are used as regular street tires on pickups and SUVs just because, but the reality is they have more rolling resistance and higher treadwear than all-season/highway designs, and they don't always work better off-road, either.
If you aren't in any immediate rush to get new tires, you could always wait a little longer and see which way the reviews go on the BFG Rugged Terrains. There might even be a BFG rebate offer similar to the Michelin offering (Michelin owns the BF Goodrich tire brand, and they do similar rebate marketing all the time) to make your decision a little easier.