If I model an NSW vs an HS24 or Harbottle both of those subs appear to be inferior to the NSW until you start digging below about 16Hz (upper bass range difference is even greater with the NSW in a devastator). From a cost perspective one 24 costs more than 2 NSWs which then pushes the SPL advantage for a 24 down another 1-2 Hz and the difference at 16Hz and above increases even more.
I haven't modelled it myself, but you are probably correct.
Big or Overly-expensive woofers don't always equate to better.

They are (hopefully) better built, but that doesn't always or necessarily increase SQ or SPL... at the desired target frequency range or otherwise.
After seeing a number of posts on this I have to ask - does one really know what they are after when they want big response in single digits? Seems like I've seen a number of posts where the priority seems to be 1-15Hz over 16-100Hz (16Hz+ is where the vast majority of content is). I'm sure I'm showing my lack of knowledge here but am I missing something?
I can't speak for others, or what they need/want/enjoy.
I could make a general blanket statement and say: yes, most don't know what they are getting themselves into or what they want. Some do, but I'd say most may not / don't.
The 20hz cutoff, isn't a hard number, it's an average-human figure, done with headphones (like 1970's headphones...)
Just about everyone can hear single digits
if you get it loud-enough. (Think rotary woofers or arrays of large subs...)
Most people haven't heard or experienced it because they don't have a system that can do it. Mine can barely do it...
"I think I can" hear or sense 1-7hz notes in the InfrasonicDeath song, but I'm not completely certain I'm not just hearing higher harmonics / THD. When I play raw sinewaves I can hear them easily down to 12hz in my system. From 12hz to 1hz things get a bit weaker and uglier, as per normal.
Hearing 12-19hz is no problem in my system, for me.
I can't speak for others but I enjoy it, personally I wouldn't want a system that couldn't play down to 1-4hz, you couldn't pay me to do it.
I don't even know WHY I like single digits so much... I mean why does a lion like killing everything in sight? Why do trees Apple? Why does the earth People? I don't know what others need/want/enjoy...
But I can tell you that it gets very expensive and is (probably) wasteful of time/money/breakers/room-volume/resources😅,
but I'm in no position to tell anyone not-to-do-it. (i.e. keep going!)
