The V6s of today are similar to the V8s of yesterday. I own a 4.3 single cab and the engine is plenty enough for daily driving and hauling a light load. If you've owned a 4.8 or 5.3 from the past, than the new 4.3 should be pretty much the same in terms of power, or even higher if you run it on E85. Additionally, the fuel economy is excellent, provided that you keep your foot from the the floor.
Yes, a V8 will have more power and a slightly better resale value, but in the end it comes down to what works for you. I didn't plan on the V6, but I stumbled on an amazing deal for my leftover SLE single cab back in August. It's perfect for my needs, and most definitely will work for you.