Super Mario 3D All Stars has remastered cutscenes, and GameXplain has posted the full opening cutscene from Super Mario Sunshine to demonstrate
Also to note is that the video source is only 720p on Twitter, so the actual in-game version will likely look even better.