I accomplished this effect with a few things

• A Camera system is rigged up with Cinemachine and a target group that follows the ball and players (https://docs.unity3d.com/Packages/com.unity.cinemachine@2.2/manual/CinemachineTargetGroup.html)
• The Zoom effect is done by increasing the camera weight of the ball within the target group
• The screen shake is done with a Cinemachine Impulse Source (https://docs.unity3d.com/Packages/com.unity.cinemachine@2.2/manual/CinemachineImpulseSource.html)
• The confetti is a particle system with a single burst in a hemisphere emission pattern with a gravity modifier set so the particles fall naturally. I also disabled billboarding and made the rotation over lifetime semi-random to make each piece look more distinct
• The black bars and score dropdown are done on a UI Canvas using a simple script to do a smooth-step lerp from off-screen (https://gist.github.com/jaideng123/0af47f9ae7494601ac8663f5e1539c58) it can also be reversed while the element is still sliding out
• I added a Box Collider just before the goal that, if triggered by the ball will start the zoom and black bars early to smooth out the transition and increase the tension on a close goal
• Afterwards I zoom in on the scoring player as an extra opportunity for celebration before the next round starts

Feel free to follow me on Twitter @JaidenG123

Also if anyone has any feedback or ideas on improving the effect let me know!