I think it's actually not that complex and the concept is really simple. I have the basic knowledge of Cinema 4D myself, and I would probably be able to do the shot by looking at the right yt tutorials if i had the time.
A Vitamin Bottle emerging to the air from under the water surface. It comes right up towards the camera. That's it, a wonderfully lit scene with realistic reflections on the bottle for the final shot.
If i had to make a reference which will sound surreal according the budget diff since we are a small business...
I would say the Mandalorian series scene with the ship coming out from the ocean is incredibly well done. - https://youtu.be/2Wmocp4iHvA?t=423
Please calm down first and let me tell you that I do realise how money affects the outcome in the digital and creative industry, most of the times.
If you know someone or you think you could work with me on this, please contact me in a direct message or write me an email to: email@example.com