There are other considerations beyond performance alone that discount the use of dynamic SQL. Speaking of writing it "right" in the first place.

Never say never, but it is something to be avoided.