when a car needs a lot of work it can be said to need this

The phrase is “a lemon” or, more specifically in repair context, “a money pit”. If you mean a car that needs so much fixing that it’s barely worth keeping, people also say it’s “in rough shape” or “a clunker.”