As far as I can tell, placing the muffler on the end of the exhaust gets a decently deep tone on decel and idle, but nothing like my system. My car burbles and rumbles around at low revs, and it just flat out WAILS on top end

FYI I don't run a tip either. Which Borla are you looking at?