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 fit in society is revealed later.