imo straight pipes on anything but a V8 sound like garbage.
Have you considered Magnaflow?
I had a Magnaflow on my '00 Sport w/ V6 and it sounded like ass. To put it simply, my wife says very little about my trucks and mods. She did call my truck a "riceburner" after I installed the Magnaflow on that truck. I removed the Magnaflow after a month and replaced it with a Flowmaster 50 Series (SUV model) and it sounded much better.
The Magnaflow droned like crazy too. I'm told that the drone in 2 door (like I had) isn't as bad on the 4 door, but I'd never recommend a Magnaflow for the V6 SOHC. Was very whiney and "inconsistent" at various revs.
I've got the Magnaflow in the garage right now. I'll slap it into my 5.0 setup someday maybe. Right now I'm really happy with my Flo Pro. I have no idea how they sound on the V6.
No one will ever convince me a V6 can sound like a V8 with ANY system. Only a V8 sounds like a V8.
There are TONS of threads in the archives on this topic. You'll get much better info if you search the archives as this site has been in existence longer than your truck has.