Yeah mine was pretty bad too. A few holes. I think there was more exhaust coming up from under the truck than the through the tailpipe. And it was very loud.
I can't help with recommendations I'm afraid. All I did was replace from the donut at the exhaust manifold to the tailpipe. Nothing special. Just picked up a muffler at local parts store.
I wish I would have put more thought into it because its too quiet now. But at the time I just wanted a beater truck to do my odd jobs. it wasn't until the last few months that I decided to fix it up and make it a daily driver I can trust to drive longer trips.
So, once I get it running the wayI want...I'll put on a little noisier muffler. Maybe a full exaust job if I can "sell" the idea to the wife!!