I do not own (nor intend to at this point) any active speakers other than a small pair in my office. I have heard the Dutch and Dutch 8C ($15,000 per pair), and KEF LS60 (price now lowered to $5,000 from $7,000). The KEFs were very nice, but not sure they were to my tastes.
The Dutch and Dutch 8Cs were a different animal, and I very much liked their SQ the first time I heard them at a show; and I believe the DSP was configured well. I have an acquaintance who owns a pair (as well as a pair of new Volti Luceras), and in that properly set up environment I thought they were brilliant.
That said, when he switched to the Volti Luceras (Pass Labs and Aric Audio gear) my jaw dropped to the floor. They are the first horn loaded/hybrid speaker that I've heard where I thought "I must have these speakers".
So yes I think that active speakers can sound brilliant, I think that many people would be attracted to an "all in one" system (the Dutch and Dutch 8Cs also stream) to simplify your system, and I also think that with very very good electronics high end speakers will sound even better