This is something we did for the first time on our last trip. We were just using it for transportation (not as an attraction in itself), but I agree that it is a magical experience. When we were boating over, the fireworks for Wishes were going.
I will add though, I'm a huge fan of all Disney water transportation.