You probably won't get "pounding" bass, but it will definitely be better than stock. I have a Kicker Substation 80 (8" tube, basically) with a cheaper amp (60w bridged) that I used in my Explorer, and it sounds better than the 6.5 sub and definitely moves more air, but it doesn't pound. When I had my Kicker setup in my Camaro with a 12" sub and 150w of Kicker amp to back it up, now that pounded!!!
As for wiring it in, that depends on what you have in your vehicle now. Give us some more details about your current setup and someone will help you get the bass you want.
Pacman