Sound on Sound has reviewed a lot of active PA cabs over the years. If you look up the equipment reviews on their website, there's a lot of useful info.
In your position, I'd keep the XR 18. It's a decent unit (especially for the money) and Improving on it significantly is going to eat a fair chunk of your £5k. Unless you need more channels, I'd stick with it. I agree with you that subs are essential if you want a solid kick sound from the PA.
The weight saved on passive cabs isn't great, when you factor in carrying power amps and the additional speaker cabling. The average class D module adds a kilo or so of weight to a PA cab, which isn't a lot, so I'd look at active cabs.
It's possible to get great sound with compact kit, but you won't do it cheaply (the formula is light, powerful/high quality, cheap - pick two). The best combination of sound and portability I've heard came from a pair of Nexo 10 top boxes plus one of their bandpass subs. It was amazing for its size and super clean and powerful. However, Nexo don't make active cabs so you'd need quality power amps, which would put their stuff well over your budget. The same applies to many of the compact but powerful and high quality rigs from companies such as DB, Fohhn (which I use), etc.
RCF have a lot of fans - deservedly - on here for capable, but not crazy expensive PA gear. Ditto Yamaha (which bought out Nexo a few years back, acquired its tech' and incorporated it into their own products). Their DXR PA cabs and DXS subs are very good. QSC, which cost about the same as Yamaha, are also worth a look.
A pair of DXR12 or DXR10 top boxes and DXS15 subs would come in at around £3.5k. If you're running subs, it's a waste putting anything larger than 12s on poles above them, when low frequencies are being dealt with by the subs. Quality 10s will be fine in all but the largest venues, which will save a bit of weight and bulk.
Spend some of the change from your £5k on some quality mic's. If you're using SM58s or similar, you can do a lot better.
It can be difficult to audition/try PA gear, but it's worth doing so if at all possible.