Be sure to check out JBL speakers as well. They're on par with Mackies. %)
Come on man. No they're not...JBLs are way better.
Anything you'd get at Guitar Center are going to be lower-end pretty much across the board (except JBL), but if all you care about is bass, then you can probably get away with a lower quality speaker as sound reproduction is much simpler in the bass ranges (just think about the difference between a shitty, harsh, treble, and a quality, clean, treble). For bass you just need the speakers not to rip apart or get blown, pretty much. You might do well to go to a smaller, dedicated, audio store that specializes in speakers and amplifiers, but given your needs a powered speaker rig might suit you fine because the built in amps are already attuned to the speakers, rather than trying to get passive speakers and mix and match gear.
I'd personally love a set of JBLs with a Yamaha mixing board. All passive, but that's still a couple thousand to get everything I'd need. A couple thousand for the entire (decent) rig IS the cost effective way to go by the way. As you've seen, spending $200 isn't going to cut it, and you're literally throwing away your money.
Peavey, Yamaha, QSC, and certainly JBLs all would be great for what you're looking for.
I've seen wedding DJs get good output out of a Beheringer or Mackie rig though. I wouldn't want to brag too much about those though.