Any speaker driver can be damaged. It depends on the design and whether the speaker system has safeguards built in. It also depends whether the output you desire is within the safe power envelope of the amp driving the speaker.
Very high-level bass (and infrasonic bass) are usually difficult for the average speaker systems to reproduce. Look at it form the viewpoint of the manufacturer; they have a price bracket to meet, and that imposes definite limitations. Very high-level bass and infrasonic bass demand voice coil assemblies that can take high heat, suspensions (spiders and surrounds) that take high excursions in stride, and (usually) amps that have both high output and overheat protection. That takes money.
I haven't seen all the active speakers out there; far from it. The few that I have seen of modest size had limiters built in to the circuitry to ensure survivability. (They were commercial, not residential.) I think that's a good idea, but it may limit the output you desire, robbing you of the goal you seek.
Needless to say, good subs come into play at this point. They will take bass signals at high level and for long term that generally aren't matched by stand-alone speakers of the same price level.
Whatever you decide, I wish you good luck. If the magic smoke escapes, you know you went a little bit too far!
Jim
p.s. - commercial speakers and subs may (I stress
may) be capable of such high output that your hearing is damaged before the speakers or amps are damaged. However, you would need a
very large room to utilize that sort of equipment ..... and tolerant neighbors.