I've been coding for 25+ years, starting out in COBOL on IBM mainframes. GOTOs when used wisely can provide an invaluable coding construct. It all comes down to the 'style' of the coder - if they use GOTO carefully and with structure, it can really simplify a code module. But, unfortunately, most people just abuse it, and they (rightly so) get told not to do that again.

Like a lot of options, use it wisely, because if you abuse it, it will bite you.

And, YES, I do still code with GOTOs in T-SQL, where appropriate.