Well it’s really a case by case basis scenario

Example #1;
You know you’re gonna use the car for more than 10 years and would like to reduce commitment (more savings or investment)?

Ans: 9 years

Example #2;
You will be using it for long, but you have a lot of free cash that’s remaining after all your savings/spending?

Ans: 5 years or less

Example #3;
You like flipping cars and just would like to enjoy a lot of cars and dont give too much thought on resale value

Ans: 5 years or less (easier to offset loan vs resale)

And the list goes on
Who cares tbh on whether you use cash or loan or ah long to pay for it

In the end as long as it doesn’t burden you and make your life miserable, it has worked for you, and only you