I have one fitted to the side of my boot, adds a subtle bit of punchy bass. Like you say, nothing OTT or really deep rumbly. I like it becuase it means I've got my whole boot space available still.
If you really want some good deep bass, then this isn't for you... but if it's just to compliment your existing speakers, then yup.