Has anyone found a good solution to this, either on the CMS or RTP side?
I have not found a good solution for this. I have tried it myself several times. Usually I just replace the rotating banner with a single message
It really depends the plugin you use and how it works.
From my experience most of these rotating banners require some customization in order to insert them into RTP campaign.
Let me know if you have any specific questions about that.