@OP I am only managing to reply to you now. With respect, you are missing the point. Small drivers in small cabinets will not deliver scale at high spls even if they do not have to reproduce low bass. 40Hz is (roughly) low E on a 4 string bass. Most bass fundamentals in rock music are there or above that and their harmonics continue further up into the midrange.
For the price point you are aiming at, you would be better off looking at a pair of PA speakers. If you want high spls and concert type sound in a large room for $1k, you’re not going to get it from a hi fi speaker, regardless of its bandwidth. So, with the specified budget, you can either have accuracy and limited ability to play loud and clean or high spls and lots of air being moved but with more ragged tonality.