It's gonna depend on your preferences. Around here, the water can start out around 40ish(Fahrenheit) before it bumps up a little as the water that isn't in the pipes exposed to the cold comes along. So we're talking a bit cold, but not ice cold.
That's during winter. At this time of year, the water stays around 50ish, which is quite pleasant most of the time. It feels cool, but not uncomfortable.
Obviously, the temp of the water is going to depend on what the pipes are exposed to. Around here, we have crawlspaces under houses, which means you only have a few yards of pipes exposed to the air to get cold. The rest is underground, where temps stay fairly steady. If you have more exposed piping, the duration of the cold water will be longer.
So, I don't even use the hot water at all, despite having it as an option. The regular water temp is nice for my preferences.