Your drive is PATA, so you can't plug SATA into it. Also, why do you care if a 7200 rpm drive maxes it out? If it doesn't, are you going to go out and buy a 10,000 rpm drive (they do exist, but are almost as expensive as SSDs)?
I will care if the PATA connection is limiting a 7200 RPM drive. I don't want to spend the extra on a 7200rpm if it performs the same as a 5400rpm.
Going to order one off ebay, it is specifically for the A1226 (2007) MPB dvd drive.