Brian74,
Removal of hardware will usually take care of a patient's pain, if the pain is being caused by the hardware. However, the patient does have to go into the surgery with realistic expectations. If the pain is not being caused by the hardware, the pain will not be any better, and could even be worsened by the surgery. That said...
It usually takes about 6 weeks for the body to fill in the holes left by the hardware removal. With the DHS (dynamic hip screw), there is a BIG hole left in the femoral neck. The smaller holes on the side of the femoral shaft are not as large.
The holes act as stress risers. Which means that they are weak spots in the bone, that can make a fracture easier. Just like perforations in a paper make it easier to tear, the holes in the bone can make it easier to break.
So, most surgeons will have the patient use crutches for a period of time. Then, no impact loading, twisting, jumping, running, etc till the holes have filled in.
Weight bearing will be up to the surgeon, depending upon how strong he/she feels the bone is. Some cases, the patient only has to use the crutches till the soreness from the surgery is gone. Other times, the surgeon may want the patient partial weight bearing for the whole six weeks. Again, that is totally up to the surgeon.
Good luck on your upcoming surgery. Hope that it takes your pain down.