I came across a webcomic called Boldly Gone which explores the notion of what happens to the average, very non Kirk-like captains just doing the 9-5. It's early days, but I think it looks pretty promising. :)