Animated splash screens would be great!
As far as I know it would be possible to provide a series of images as individual files that could be played in sequence.
For the beginning, you could provide your animation frames as a packed zip file here. We could come up with a menu entry in the RetroPie Script to choose between different splash screens.