My first serious DSLR was the Sigma SD9 - a raw-only camera. Then I upgraded to the SD10 - still raw-only. Those were the days of sublime simplicity. What you shot was what you got.
Then along came the SD14 with in-camera JPEGs but no scene modes. The in-camera JPEGs suck, so I still shoot raw with it.
I never indulged in the SD15, so the next up was the mighty SD1 Merrill which does come with what they call color modes (classic photography - yet another name for the same thing!). The modes are all much of a muchness, not too extreme and the resulting JPEGs are quite good but I use Standard Color Mode for one simple reason:
Not being one for letting the camera do anything other than shoot the scene, I checked the meta-data (3x3 matrix) for each color mode. Standard mode is the only one that doesn't mess with what the camera captured. With the Sigma converter and a raw capture you can always change the color mode in post, as you can the WB, if so desired. However, for all the usual reasons, I still shoot raw with the SD1M.
In my view, post-processors like RawTherapee do a much better job with their infinite variety of processing options and saveable sidecar files.
I'm saying that, on the only DSLR I own that has scene/color modes, I only "use" one of them and that only with it's contrast/sharpness/saturation set firmly to zero (neutral).