Non-adiabatic Photochemistry: Ultrafast Electronic State Transitions and Nuclear Wavepacket Coherence