There really isn't a point of a pick-up in the city (where I currently live). I mean there are a few rural areas on the outskirts, but most of the roads are either paved or smoothed out. You'd really have to go out of your way to find a horrible road. Most of the roads that people think they need a truck or SUV for, I can traverse in a FWD sedan if I go slow enough.

Anyways, if I was to get a truck, I'd get a small truck with just the basics. Single cab with short bed since I wouldn't haul much. Those mini pickups make good commuter vehicles though. I wouldn't mind having a small 4-cyl 5-speed pickup to use as a personal conveyance.