some diesels can be quite nice. I had a golf tdi for a while. the engine was basically silent at highway speeds, and it was honestly a bit better for city driving than my hot hatch. too bad it turned out to be illegal.
I agree with you on the Q5 though, but only because it's too big.
BUT: Every single time I drive on Diesel, I feel like I should have gone with a pure electric car: Driving on battery just has a much better feel to it. That's with a 70hp electric engine (not much for a 2t car) and a really well behaved 215hp diesel engine (it only "roars" when it delivers a lot of power, but during normal driving it's calm).
The point is: Don't go with the Q5 Hybrid if you can avoid it ;-) If you can afford it, maybe lease a cheap/nice car for a year (or two) and see what the BEV market has to offer then. You won't regret it (and worst case: Save some money by buying a Q5 as leasing return).