I've found the Starship's Mage series by Glynn Stewart very entertaining.
Premise: interstellar flight requires you to have at least one mage on board who uses their magic to move the star ship by a light year but then needs to sleep off magical exhaustion for several hours.
How and why mages developed and where they for in society is revealed later.