If you're shooting RAW then the profile you choose makes no difference in your post processing, it only impacts the JPEG preview. Some editors are able to apply the camera profile to the RAW image - Nikon imaging software, I believe, does it automatically, while Lightroom/Adobe Camera Raw have profiles that are a close approximation of the in camera profiles.
For my workflow I apply "Camera Standard" automatically when importing into Lightroom since this is what I use in-camera. I sometimes will change this, but more often than not I just use the Develop module to adjust my colors from there. The advantage of using the color profiles is that your starting point can be changed in such a way that you can get more out of your sliders if you want to go extreme in your edits. For example, a high contrast profile will still start your Contrast slider at 0, so if you move it to +100 it will be more extreme than the same slider setting starting with a low contrast profile. That's a very specific and atypical use of profiles, but it's an example of why one might want to play with them.