My favourite bad comment is
"recreated it by using more functions instead of joins"
Followed by a nest of scalar functions and while loops. It happens to be one of the worst offenders for timeouts in our application. I've had a stab at speeding it up, but at almost 800 lines I just get lost in it.
I suppose the comment itself isn't so bad, it does describe the problem - just what it represents!