said by John Galt6:Unless you have masonry skills, you're going to have to consult a professional.
Hmm, darn, that isn't what I wanted to hear

I was thinking it may be just a simple - Pull the metal part out and feed a new (proper) downspout up after clearing out that cement, then sealing it from above onto it with caulk or the like, then using spray foam around where the downspout comes out.