There is one gotcha for CMYK content in InDesign. Here, the default policy is to "Preserve Numbers", which is the same as "Assign Profile" in Photoshop. There are good reasons for this (mainly to avoid K-only black turning into 4-color black) - but images should normally be kept RGB and standard procedure is to place RGB images. This will always be treated and displayed correctly in InDesign.