They're ALL annoying, if not for you, for your neighbors. LOL.
If you have a turbo, you may see improvement.
If you have a NA engine, you'll likely LOSE HP.
The butt dyno will increase tho!
I run TT Borla products in my VWs and like them. Recently(well, several years ago), they came out with a venture tip with removes most of the drone inside and out. I like 'em. Had over 200K on one of them.