I put a Dynomax Super Turbo cat back system on my 2001 Ranger 2.5L. I was a little nervous about putting exhaust on that truck since it was an I4, but I read reviews of the Super Turbo online and they generally seemed very good.
It had a nice low tone. No flatulence noise. It wasn't a great deal louder or different sounding from stock, it was just a deeper note with much larger pipe and a smaller muffler.
A lot of people did notice the exhaust though, for better or worse. One guy with a Frontier at a car wash asked me if it was supercharged...that was good for a laugh since it was an otherwise stock 119 HP engine under the hood. Cops noticed too and liked to pull this truck over noticeably more than my other trucks.
Overall, it was a good upgrade to the truck. Looked nice, sounded decent, and certainly didn't hurt MPG (though I don't know how much it helped). I don't think it was obnoxious at all, and the older guy who bought it from me didn't seem bothered by the exhaust at all.