Tight Ends off the street

In view of us grabbing tight ends off the waiver wire or less, would a top-tier pass catching tight end, like a Tony Gonzales, make us an elite offense or just take catches away from our other receivers?

We would have to be better in the red-zone and hot read patterns off of blitzes right?