Firstly what a great forum so much great information

I’m currently seriously considering buying an x5 40d MSport. After reading a fair bit on here it does seem that the 8 speed box is worth having. I have tested the car and have a 330 Msport currently so I don’t mind the ride too much.
My question is I have read so much on here that I have started to worry myself about the reliability. Would you say it is not worth owning an older x5 without some form of warranty in place as a lot of repairs can be so expensive e.g. transmission failure
Realistically I’m looking to spend 16K maybe a bit more for the right one. But they most likely will involve the car having travelled 80k in miles.
Have many owners on here been lucky and had few issues or is this something I really need to consider.
I have tried to make a fair few buying notes things to look at etc.
But any advice or guidance is appreciated
My Likes are
40d Msport due to the body coloured bumpers, oval exhausts and wider arches
The 8 speed box
The pano roof looks great - But should I avoid this due to issues? Or are they ok for some on here that have them?
7 Seats would be a bonus
Im aiming for around a 2011 plate or slightly newer, Is it worth getting a 2012 plate because of extra standard functionality?
Any advice greatly received , Thanks in Advance
