If all you want is the effects like the cube rotation, it shouldn't be too hard to add them to hildon-desktop. The reason the transitions are kept fairly simple is mainly because it's nicer, not because of limitations.

Porting compiz doesn't really make sense to me, unless you want to have multiple windows on the screen. But I can't possibly see that being useful on the small display, even with a stylus.