I have a couple of the Metabones adapters, which adapt a Canon EF mount lens to a Sony E-mount body. I've used these adapters on an a6000 (which I own) and an a7RII, which I have access to through a friend.
One that I have is the (more common) Mark IV adapter. It works with EF (full-frame) or EF-S (crop-sensor) lenses. There are no optics in the adapter, but definitely some embedded electronics to engage the focus mechanism of the attached lens.
I have about 15 or 20 different auto-focus lenses and at some point, I've attached nearly all of them to the Sony just to try it out. Many of my Canon lenses do "okay" with this adapter. A few lenses do "well". Some do not work at all. There are only a few that I think perform well enough to consider using in a practical situation.
The (Canon) 70-200/2.8 is one that performs fairly well. The 24-105/4 is ... well, not that great. It works, but there's a lot of hunting involved. I have the Mark I version of that 24-105 lens. It's possible that the Mark II is different/better, but I can't speak to that one.
And just to make sure, I mounted that lens/adapter/body combination even as I write this response to check things.
Also, regardless of the body (or adapters), I don't think of the 24-105 as a great lens for low light because it's f/4. On a full-frame body (with better and larger pixels), it's certainly adequate, but this is not a lens that I think of when considering low-light conditions.
The other adapter I have is the "Speed Booster". That adapter includes an optic (actually, 4 elements) that Metabones says will "reduce the effective focal length". It does this by focusing the light circle into a smaller circle that's still big enough to cover a crop-sensor (like on the a6K), but no longer big enough for a full-frame sensor (like on the a7). Therefore, I don't think you're interested in this adapter.
For what it's worth, many of my lenses will work with the Speed Booster, but not all. And it's not the same set that doesn't work with the Mark IV adapter. At one point I made a list of which lenses worked with which adapters, but got tired and bored with trying to keep track of that. Basically, some lenses work, some don't. There are multiple sites and reports on the internet that detail this out.
The Metabones adapters are not cheap. Definitely not cheap. There are alternatives including Fotodiox and Novoflex, and several other (even cheaper) knock-off brands. I borrowed a Fotodiox once and the Metabones was definitely better (meaning faster on a few lenses) and more compatible (meaning that the Fotodiox didn't work on at least one of my lenses that the Metabones did).
It doesn't strike me that the A7SII body and 24-105/4 lens is a great combination, and by the time you add an adapter, it isn't cheap. As a student, you might have a constrained budget. I'm not sure how this combination would be recommended when viewed objectively.
Ultimately, I got tired of adapting Canon lenses to the Sony body and got the (Canon) M5 body. Every single AF lens I have works quite well when using the EF to EF-M adapter. I haven't decided to get rid of my Sony yet, but definitely considering it.
