Switch from BMW (325i) to Audi A4 (2.7TDI)?

Hello, currently have a service car, BMW 325i, 6-cylinder, gasoline and am very satisfied with it!! The lease agreement expires and a new purchase is imminent. BUT: the BMW 325i is significantly higher than the Audi, A4, 2.7TDI, in the mtl. Fullservic leasing rate by over 10% more expensive!! What is decisive is that the residual value of the A4 (after 5 years, 125,000 km) is significantly higher than the BMW. There is no significant difference in the purchase price. d BMW (4-cylinder) leased: a test drive, however, disappointed me with the noise level of the car (diesel)!! Now I have completed a test drive with an Audi A4, diesel, 4-cylinder and was very positively surprised by the driving noise (very quieter, quieter than the BMW). The Audi salesman told me something about a new technology in the Audi, which is why Audi is “in the lead” here (don’t know me). I find it very difficult to say goodbye to my 6-cylinder, but if I’m on a test drive, I’m not sure about it. My questions: 1. Does someone have experience with a change from the 325i BMW to the A$ 2.7TDI regarding the noise level or the quietness of the two vehicles? 2. Does someone have similar experience with the residual value estimates between the two vehicles at 125,000 km, 5 years or does someone have a tip where I can get comparative values. Thank you! mfg