Will high horsepower (aka. high torque at high rpm) make a full size 2wd pickup accelerate fast?

Does high hp really make a vehicle fast? or is low-mid torque the way to go for acceleration.