Wading into layouts here, forgive the pedestrian questions.
Is there a way to rotate text frames in layouts? I read this (http://www.manifold.net/doc/mfd9/layouts__text_frames.htm) but perhaps I need to do this via SQL?
You might also look at:
The rotation would work if you create labels that are line labels, and then when you rotate the underlying lines the labels should also rotate. Note that point labels, like the "N" for the north arrow in that topic, will stay right side up even if the projection is rotated.