There's no perfect configuration.
I've owned both the access cab Tundra with full size bed and double cab Tacoma with 5ft bed. I've also owned a Mazda B2000 single cab with 7ft bed.
You listed the number of door for access cab as 2. My Tundra actually had 2 regular front doors plus two "suicide" doors behind them. You had to open the front door in order to open the rear door which opened 'backwards" (the reason suicide doors are named as such). So, technically there were 4 doors, or more like 2+2 (2 doors plus 2 half doors).
As a truck for hauling, the larger the bed, the better. I owned motorcycles that would not fit in the smaller Tacoma bed. Sold my bikes, so the next consideration would be hauling green waste and furniture on occasion. If I ever buy another bike, which I only anticipate if I'm living on the mainland, I'd prefer a trailer to haul it when needed. Getting an 1100cc monster into the bed of a truck up a ramp is not fun.
For passenger space, the Tundra's access cab was adequate. Usually only had my young kids in those seats, but once in awhile I'd give rides to lunch for coworkers. It was cramped for them, but it was only for a short distance.
Now that I live alone, I can see getting just a standard single cab again with no rear seating at all if I felt I still need a truck.
Personally, I'm leaning towards an SUV -- something large enough to haul a good amount of cargo while offering a versatile seating arrangement.
My daughter bought a Toyota Sienna mini-van last year. All the seats can be stowed or slid out of the way so it's able to haul quite a bit. My old Plymouth Voyager required that I completely remove the rear and/or center bench seats to increase the cargo capacity. Having 2 kids in car seats, her Sienna is the perfect vehicle for her.
I can see a Sienna meeting my needs as an alternative to an SUV. I drove it last week for an afternoon of errands, and I really liked it.
Poll