The X3 is the perfect family SUV - the G01 offers 550 litres of boot space, comfortable rear seats, and the B47 diesel delivers 55+ mpg. The G01 is the family X3 to buy; the G45 is the future.
The X3 is a great commuter - the G01 20d with B47 returns 55+ mpg, the CLAR platform is comfortable, and the SUV driving position is popular. The G45 is even more refined.
A cheap E83 or early F25 N47/N20 is not a cheap X3 - it's an expensive one with the first year's bills prepaid by nobody. A £8,000 F25 with B47 (2015+) is the bargain; a £4,000 E83 without chain paperwork is the trap.
The G01 X3 M40i with the B58 is a genuine performance SUV - 355–382 hp, xDrive, and the B58 is one of BMW's most reliable modern engines. The X3 M with the S58 is the full M experience - 473–503 hp and track-ready.
The E83 M57 3.0d is a classic keeper - one of BMW's most durable diesels. The G01 M40i with the B58 is the modern keeper - the B58 will outlast the car around it. Both are worth proper investment.