I have been looking into the same thing for a small 2nd car. In the end I have just taken out a M&S Car Loan which has a residual amount after x years. Their on line calculator is very helpful. It turned out far far cheaper than taking any dealers’ finance on both new and nearly new cars.
Yes after 3 years I need to decide to pay off the loan and keep the car, continue with the loan, or sell the car to pay off the loan, but there are no admin fees, options to buy, or excess mileage charges or haggling over condition of the car etc.
All in all it puts me in charge and not the car dealer, leasing company. My comparison is really based on Personal Loan, versus dealer HP, versus PCP and not pure leasing (3+x).
Plus the interest rate is the same whether I buy a new or a used car. VW finance is roughly twice as much for 2nd hand versus new.