How much power do engine mods yield?

Does dual exhaust really make enough of a difference to offset the time and money it takes to do it? I've heard it does and I've heard it doesn't.