Want a new camera but not sure

I am looking for a new camera, i mainly take photos as of now but i want to do more video (b-rollish) type of work. More specifically take cinematic video of cars. I was wondering if the canon rp was a good all-arounder, if you have other suggestions let me know. i also heard the a7iii is good but its really expensive