Welcome.
2006 is the end of the E53 era, and manual ones are very rare. The E70 which appeared in the UK within a few months of production starting early 2007 is auto only. If you can afford to, go for the Mk2 (E70) rather than the Mk1 (E53) as the tech in much newer and transmission more reliable. The original E53 is based on 1999 tech borrowed from LandRover.
On the less positive side. As with any luxury car the running costs can be very high. Your son will need to get hold of a copy of the BMW software to do diagnostics. Generic systems simply won't help decode anything in meaningful ways. V8 petrol models are very thirsty - but then you expect that from 4.4/4.8 powered units. Diesels are typically in the high 20s to mid 30s fuel wise and for both VED is or can be high depending upon year. Later ones are better on VED.
If you are towing then you may need to find one with uprated towing capacity to 3.5T. The default is 2.7T. The upgrade added additional transmission cooling, uprated suspension at rear and a bigger fan.
E70s are fitted with run flats and all versions are sensitive to incorrect tyre types, to the extent it is possible to shatter diffs and transfer boxes. More and more members are reporting issues, and though numbers are low, they are high enough to make ears prick up. The rise in 20"/21" RFT shod cars is harsh. I don't find it so, but it doesn't appeal to all.
On the positive side the E70 X5 is a fantastic drive. Comfortable, quick, handles well and looks good. The tech is much better and the cabin is a nice place to while away the miles. The SD or 35d badged versions are twin turbo and the V8 is also available with two hairdryers...

. Diesels are all 3.0L IL6 engines regardless of badge numbers.
I suspect many smaller garages never get to see the cars because they need specialists who know their way around complex electronics, computer based cars, hi tech gizmos and less than intuitive ways of doing things. Getting some parts is tricky if not buying OEM. Nothing unusual though at that end if the market.
Whatever you go for, take your son with you and a fine tooth comb! You'll need it to check everything works and does so properly. The time taken is worth it and there are some really good ones available.
And
