Do you want pure SPL or really loud music? You want to figure out what bandwidth you want the sub to play. You might want to find out the peak resonance of your vehicle, too. A properly designed sub box will typically be loud across a wide range, if the woofers are of decent quality.
Based on all of my experience, I really like the inherent design style of DC woofers. You typically have strong motors, good throw and cone area, but they have a relatively soft suspension. The small box size + the strong motor + the normal cone size = musically loud bass. Woofers that want smaller boxes can sometimes inherently play more loudly and evenly across an entire musical bandwidth, just due to the way the small airspace dampens the cone movement, vs a larger box sub that might have greater peaks and dips due to air damping/impedance factors that are related to ported boxes unloading away from tuning.
There’s other woofers that would probably meet this criteria besides DC. DC’s just seem to be really good and powerful in their relatively small boxes. I really like using them in series 6th order bandpasses, because you can fit a ton of motor force and cone area in something like a b-pillar wall, vs a bunch of 12’s that need .5-1 cubic feet more airspace per woofer.
At the end of the day, it’s usually all about box design and amplifier quality, including quality of signal and enough solid voltage to power through impedance changes with a ported box at all the different frequencies. For being loud, box design, maintaining high DC voltage, and amp quality are typically more important than really nice subs. I can take an $80 or whatever Q Power deluxe and be louder with a good amp and box than say someone a $500 sub that’s underpowered and unloading or starved for proper wave-energy flow.
Just make sure you truly have the space for doing a proper box for whatever subs you pick. You might try to fit a 4000w 15” in the trunk, too. That might be an option.