If you want hard hitting and low cost then don’t go too big. In general, the bigger the sub the bigger and more expensive the amp needed to drive it. What kind of budget are you talking?
IMO definitely DIY install. Roll your own wiring, don’t buy a kit. Spend the money on the sub/amp/enclosure not on brand name wires and connectors.