Buzzkill247

I was looking for the similar - Deep throaty rumble with in town panache, but not window breaking loud - yet a good roar in WOT. After hearing a lot of various exhaust combos, I was tempted by ARK (for various reasons opted against) and wound up ordering FI RHFC and 18" R- TDX CBE w/ CF muffler. IM ever so Z newb HO, I felt it was damn near the perfect honoring of the VQ sound without being "ricey" ... to me! I'm 42. In my 20s when I had my 93 5.0 sedan I wanted to break windows and eardrum. Now, I just want a sound that she deserves and tuned performance to match. As frame of reference, Greddy and HKS were too loud and not refined enough... for me!

Now... that all said... Resonated cats or Resonated TP is the way to limit the hiss. you won't get rid of it per se, but it will be muted and not sound like an Autozone wannabe. (or leave stock cats on, but accept performance drawback)
Mid pipe will not only play a part in resonance and tone, but also in flow, which brings us to the next part...
You want LOUD you say, ok... loud all the time, or just on WOT? That will make a difference on what can you go with. Baffled cans will often give you more of that loud pop and putt, but all the time (often seen in large cans with multiple outs, letting the exhaust resonate against itself using sound wave pressure to create the tone and pop you want) Fiber/ported/muffle cans are more likely to give you nice tone on normal driving, and mid to loud on WOT.

my opinions. my experience, but hope it helps a bit

Sounds almost like you want something along the lines of:
Resonated test pipe (or Hemholtz style - think ARK test pipes with that "tank thing")
H-pipe mids (instead of Xpipe) - maybe AAM or ARK GRiP?
muffler delete large (read as over 12") resonator with short tail - think AAM style
Am I close? lots of youtube out there, varying sound quality but you can get a good idea