Question

what happens to a sunset/sunrise photo when your camera is on automatic?

Answer 1

Depending on your framing and how your camera sets exposure it could be way off in either direction. Also, auto white-balance tends to try to "correct" the warm light, making the sky look rather gray. Once you have manually set the white balance to daylight, use the exposure-lock feature to set the exposure for the sky.