[Mackser]

Are there any good videos showcasing a productive Emacs setup like this and how it's used for everyday tasks?

[darshanime]

not exactly what you seek, but i like the emacs rocks clips: https://emacsrocks.com/

[internet_points]

they're nice and short, but note that the latest one is 8 years old ;-)

(though https://www.youtube.com/@emacsrocks has newer stuff by the same person, seems like game dev in clojure and emacs)

[kevstev]

https://systemcrafters.net/emacs-from-scratch/

This was my aha! moment where I actually watched someone install and use packages and was like oooh yes, this is both nice and will actually be very helpful. And I have been using emacs since 1998! I find most package pages tell you a lot about the how, but very little about the why on you would want to use them.