The PS3 really doesn't care what kind of SATA hard drive you put in it, as long as it's no bigger than 1TB. IIRC, that's the maximum the file system can read.
Like Fallen Kell said, I'd stick with the 9.5mm hight drives, which should include most 1TB ones these days. There's not much room in the bays for the fatter ones.
The PS3 will take any SATA SSDs. I don't recall there being any compatibility issues with those. PS4 is a different story though. Not worth it IMO. The larger capacity ones cost more than a new console anyway.