Of all the former WWE legends to pick, why did Vince have to go with the Rock?

Because the rock has the least amount of self respect out of all the guys you mentioned. So he is perfectly fine with working in such a crap place like the WWE.