Check out Sweetwater’s pro sub selection. From $400 8 inch JBL to $5K 15 inch Genelec! Must have dual balanced inputs for most all except Focal which offers a 2.1 LFE bypass input. They have great sales support as well.
i think key is proper system integration so bass doesn’t “boom” but just sounds like low end extension from your main speakers. My 12 inch 600 watt Klipsch is set on first gain notch w my Focal Arias and notch two with Klipsch Fortes. Can’t tell a sub is in the room but there is definitely a 360 degree low end drive that extends the soundstage.
Good luck!