I would rank the factory sub as "not bad" for what it is and the power you'd need to run it, and great for the space it requires. Is it awesome? No, not compared to something like a good aftermarket sub (or even a JL Stealthbox) powered by a proper amp, but the factory sub certainly digs fairly low for what it is, and its oval size moves similar air to a 10" woofer. Add a decent mono block amp that does 300-400 watts RMS into 2 ohms and an aftermarket head unit, and the factory sub's sound can be improved further. Most of the underseat type of self-powered subs will reproduce a portion of the bass spectrum (and will certainly produce
some bass), but just don't have the throw to move enough air in a way that compares to a traditional sub.
I know it comes down to expectations, the money you are willing to pay, and the space you are able to devote to good sound. An inexpensive plug and play option is a win for the people chiming in here in your thread, but with a little work, careful equipment choice (i.e. choosing a good subwoofer that works with a small air space, and building an enclosure that is perfectly sized for it) and marginally more money, really good bass that surpasses the plug & play options can be achieved- that was my point. Not everyone wants or needs SQ quality bass in a daily driver, and many people value plug & play over performance. It really boils down to what sort of performance you are wanting and what you are willing to do/pay for it. I moderated an audio forum for years (same username) and have installed and played with many products in the last 35 years from mild to high end, and found more people displeased with underseat subs than happy.
You can make a removable box as small as .75 cubic feet for a decent middle of the road 10", bump that up to a cubic foot for a similar 12". There are some very capable 8" woofers that outperform the underseat type subs that will work in a half cubic foot. A decent entry level sub can be had for either side of $100 depending on what you want. There are some lower budget mono amps for similar price that don't suck (and many that do)...for budget amps, PPI/Soundstream has some that will do rated power near that price point. A sheet of MDF to build an enclosure isn't terribly expensive, and a sealed enclosure of the correct size that is removable won't take a ton of room. Building your enclosure to fit on the side of the cargo area like the Stealthbox is another option that will maximize cargo room and minimize footprint. Going this route will give you a better shot at realistic sounding bass, closer to what a good home system provides and doesn't have to cost a lot or draw attention.
^^ the Stealthbox is expensive for what it is, but for illustration purposes, that is where it mounts
If you can, demo the factory Alpine sub in a Jeep (again), and demo the products mentioned in this thread by other members. I have no intention of pooping on the opinion of other members, but do hate to see people spend money and get disappointed with the results. They aren't disappointed, but may have different expectations- find out what yours are and then choose accordingly.