You probably don't even need to shell out for an elgato camlink. Most halfway modern canon cameras are supported by their webcam tool (iirc they expanded support to a lot of models during the pandemic) and I'm pretty sure that Sony has an equivalent as well.

If you're on Linux there's a way to make this work with gphoto2, but it involves a little bit of fiddling and is less plug and play.