The classic Confederate officer with Northern roots is Robert Stiles. This book has to be in a respectable library of Confederate personal narratives.
http://docsouth.unc.edu/fpn/stiles/summary.html
http://docsouth.unc.edu/fpn/stiles/stiles.html