Which CMYK profile should I select?

The best option to select in Photoshop is U.S. Web Coated (SWOP) v2.

 

Within Photoshop, go to Edit -> Colour settings -> Settings -> North America General Purpose 2

 

Within Colour settings > Working Spaces > CMYK > U.S. Web Coated (SWOP) v2