If you want a really good example, the northern lights are a good one. The majority of the color is something you cannot see with your eye because it's too dim for the cones to pick up. A camera doesn't have this limitation.

See: http://www.space.com/23707-only-photos-reveal-aurora-true-co...