Room size really is the biggie. In an apartment, it's highly unlikely that you're going to need massively loud output though. Even if your apartment is physically large enough to make use of it, I doubt the neighbors would be too pleased
Decoupling your subwoofer is going to be very important in an apartment! What good is a nice sub if it gets you nothing but complaints and you can't even use it, right? So factor in $50 for an Auralex GRAMMA isolation riser. You can pick them up at Amazon or Sweetwater.com.
There are a number of good choices in your budget range and for the content that you say you listen to.
The SVSound PB12-NSD (or the $20 less expensive PC12-NSD cylinder version) stands out in the under $800 price range as being one of the most capable in terms of sheer output and also one of the least expensive subs to truly deliver 20Hz output that is about equally as loud as the rest of the frequencies above 20Hz. If you really want to dig down for some of those action/fantasy/sci-fi movies, or you want to play organ music or electronically generated music with synthesized bass notes, then the "entry level" SVSound NSD ported subs are very good candidates to consider. One other really nice thing about SVSound's subs is that the new "Sledge" DSP amps that they are using are really a cut above, and make the subwoofer essentially unbreakable and incapable of producing high distortion. Crank the volume all you want. SVSound's subs will simply play as loud as they possibly can without going into high, audible distortion. But they won't play any louder. And thus, you never run the risk of damage or bad noise. It's an especially great feature if you move to a much larger space in the future where you can really crank the volume
On the low end of your price range, the Rythmik FV12 is easily my favorite $500 sub. It is the least expensive sub out there that really doesn't have any obvious weaknesses. It has good extension to just below 25Hz. It plays clean and tight and accurate. And similar to the SVSound subs, it's basically impossible to break or drive into high distortion. Really well engineered. It isn't capable of the same output as the PB/PC12-NSD, nor can it reach right down to 20Hz with quite the same authority. So that's what the extra $200 or so (I'm factoring in shipping, which is included for SVSound, but about $60 for the Rythmik FV12) gets you when you go from the Rythmik to the SVS
In between those two, you've got a few other great options in the HSU VTF-2 MK4, Outlaw LFM-1 Plus, Outlaw LFM-1 EX and HSU VTF-3 MK4 (listed in order of price from $550 up to $700).
Outlaw's subs were designed with considerably input from Dr. Hsu, so the performance between Outlaw and HSU subs are very close. Dr. Hsu makes extremely good use of "off the shelf" parts and very good engineering and design to create accurate, controlled sounding subs that perform very, very well for their modest asking prices. I'm a big fan of the HSU VTF-3 series. Do make note of the physical size though. They are BIG
The VTF-2 and LFM-1 Plus play in the same ballpark as the Rythmik FV12. They are all much more similar to each other than they are different. I personally like the FV12 just a touch better because it's $50 less expensive, plays just a couple Hz lower, and gives up nothing in the other important areas of transient response and accuracy. The LFM-1 Plus is a champ in sheer output though. It is essentially the exact same sub as the old HSU VTF-3 MK2, but at a $550 price point instead of $700, which is just amazing.
The LFM-1 EX and VTF-3 MK4 are step up models - and the higher price reflects that. Here you have subs that are getting very close to the SVSound PB12-NSD - trading minute advantages back and forth. The LFM-1 EX isn't quite as linear, but it's got plenty of 20Hz oomph. The VTF-3 MK4 is perhaps the most balanced out of the lot, but there's its physical size to consider and it's somewhat different side-mounted driver position. And both the LFM-1 EX and VTF-3 MK4 CAN be driven into high distortion or even bottoming out the driver with high enough playback levels - something the SVSound's DSP "Sledge" amp won't ever allow.
If you want to take up the least amount of floor space, the SVS PC12-NSD cylinder is unmatched. By being a tall tube rather than a squat box, the PC12-NSD cylinder takes up very little floor space. And if you hate the height, or want to hide your sub behind a couch, you can place the cylinder on its side with absolutely no problems, at which point it is only 16" high, since that is the diameter of the sub!
So - my personal top choices with your budget would be the SVSound PB or PC12-NSD, followed closely by the HSU VTF-3 MK4 if you can manage its LARGE size. The Outlaw LFM-1 Plus is an output champ if you want the lower $550 price tag. And if you just want to keep the price at a minimum while getting "no obvious compromise" performance, there is no better $500 sub than the Rythmik FV12.
In so far as Epik goes - personally, I'm not a fan. I don't like the amplifiers that they use. And the driver quality is necessarily a little bit lower because Epik is using two drivers while keeping the price of their subs very low. Don't get me wrong, Epik's are NOT "bad" subs". But their focus is on deep extension and they're willing to compromise in the areas of distortion and cleanliness of the sound in order to get there. My biggest problem with their sound is a lack of delineation. I find that bass notes tend to "run into" each other. I just don't get the separation of notes that an HSU/Outlaw, Rythmik or SVSound sub offers for a similar price.
Elemental Designs (eD) is another sub maker who favors deep extension and slam over "tight" sound - at least with their ported subs.
Personally, I feel that there are more than enough choices that I really like in this price range that I don't feel there is any need to compromise on any metric. An HSU VTF-3 MK4 or SVSound PB/PC12-NSD would definitely be my choice with your budget and taste in content. I know those two are towards the top of your budget, but in cases like this - where the competition is fierce and the extra money really is going into higher quality components and design - you genuinely do get what you pay for.
And again, be sure to decouple what ever sub you get. Avoid that structure-borne sound transmission and you'll have much happier neighbors who aren't being bothered by the "thump, thump, thump" that we all suffer and know all too well!
I hope that's helpful to you. And again, I'm not "hating" on Epik or eD - they're just not my personal cup o' tea, but there are many, many happy buyers of both, so this is purely just one man's opinion
Best of luck in your decision! The very good news is, no matter which sub you get out of this selection, there really is no "bad" choice. They're all very good. I'm just trying to convey the
slight differences that might make you prefer one out of the bunch