The last car our family bought was a 5 year loan...but it was at 1%. Unfortunately, we desperately needed a car and this was during COVID when used car prices sometimes exceeded new car prices (which never made sense to me). Before that, the last car I bought was lightly used and was a three year loan. Don't remember the interest rate but it was paid off in 1 year. A new car should be usable for at least 10 years though with minimal maintenance unless you are really abusing it.

I'm not much of a mechanic so I tend to want a car that is relatively new and preferably with some warranty left on it.