Has anyone added a small subwoofer to 2 channel and been thrilled with the result?


The subwoofer can of worms.
I’d like to add some bass to my otherwise fine 2 speaker setup and have limited space so perhaps a single 10in?
After a few weeks of research the only conclusion I can come up with is - everyone agrees they have to be setup properly. Every brand and technology has their own following and most recommend using 2 (which I don’t want due to space concerns). My room is 12 x 13 ft with box raised ceiling.
After much research, these are the subwoofers I’m trying to pick from, for various reasons:
Rythmik FM8  - lots of hifi fans
JL audio e110 - fantastic support
REL T/9i - sort of a gold standard
KEF R400b - interesting technology, makes me grin. 

I've never heard any of these.
System:
Hegel H160
SF Concerto speakers on stands.
Ben
casteeb
If using an active crossover that also has capability to connect a sub(s) and vary crossover points for the main speakers and the sub(s), my understanding is to set the crossover on the sub to it's highest value and then use the crossover to set the actual sub crossover point.
Am I wrong about that?

Like danatek2 said....
I was searching for a relevant sub that would compliment a pair of Maggie 3.7i
ribbon speakers and tried a half dozen of the more popular (and expensive) offerings.  All sounded muddy and out of sync as the Maggie's are very fast and accurate.  At an old time music lovers suggestion, I was told to look for a short throw,  sealed sub no larger than 10" to make sure it would damp quickly.  Found a Martin Logan Dynamo 700w and that was it!  Within minutes of trying it out in my home system I knew I had found what I was looking for in bass re-enforcement.  Fast, accurate, with no boom or after tones ruining the main body of the music.  Best part?......it was $600 bucks.  Subs have to have synergy with your room and existing equipment.
Having gone through 3 or 4 subs that filled out the bass but whose integration with the main speakers always seemed so-so, I finally found the seamless integration I was looking for (with SF floorstanding speakers) through a software-configurable Elac Adante SUB 3070.  I think two factors were responsible for the difference: the smartphone microphone-assisted setup that is then further customizable via the Elac app and the design of this sub that incorporates 2 diagonally-opposed 12" woofers.  This sub is designed for music, not AV, and aided by drivers that point into the room diagonally, it never hints at boominess, and it reveals little of the sub's positioning.  This is not a small sub, but it is certainly smaller than two 10" subs, and given the lows it can reproduce, making room for 12" drivers is certainly worth it.  The fact that its cabinet is furniture-grade also eases the inconvenience of accommodating a big box. 
I added a Gallo 10" sub to my German FJ  2 Way loudspeakers. It is 300 watts and goes down to 18Hz. It is fully adjustable and I was able to integrate it perfectly with the speakers. I set its crossover setting to 50Hz I connected it with the 2nd set of outputs from my preamp. I didn't have a lot of room for a sub, so it being only 10.5" wide it fit nicely.