Some good advice above. I'm a fan of mini array plus sub' PAs, but, as always, quality costs. The better ones work very well and their advantages (for me, at any rate) include resistance to feedback, even coverage and clarity, as well as relative compactness and lightness.
Some do, as Bill points out, require you to place the sub(s) beneath the columns, which can cause issues. Others, like my Fohhn system, enable you to mount the columns on stands and place them and the sub(s) wherever you like.
When I bought my system, I was playing a lot of Irish and similar music - combinations of acoustic and electric instruments plus voices - so I particularly wanted clarity. I auditioned a number of stick and sub systems (not easy, as few if any dealers stock a range of them, so a bit of travel and time was involved).
Mine sounds like a giant hi-fi - very clean and clear. It isn't a bass monster (I appreciate that additional subs could address that issue) and it wouldn't have been my choice if I played loud rock music and ran a lot of drums and bass through the PA. It will handle them happily at reasonable levels, though.
Two subs (with onboard power amplification) and two columns set me back £7k about ten years ago. So adding a mixer, mics, etc will put the cost of the PA over £10k. Not cheap for something that gets used mainly in pubs and smaller venues, but it's been uber reliable and, being made in Germany rather than China, can be repaired should the worst happen.
Try to audition a few and don't buy on the basis of recommendation. In the end, you pays yer money and takes yer choice.