I need help choosing a camera🙏

Hello, I am an amateur car photographer, and I was thinking about getting a a7ii. I was wondering if it is good in low lighting? And if not then what camera would yall recommend?