"What are the *worst* arcade ports to appear on 8- and 16-bit consoles?"
As much as I played the hell out of the NES port of the TMNT arcade game as a kid, yeah... no, it does not in any way, shape, or form hold up at all to the actual arcade game.
Aside from Mortal Kombat (which did indeed suck on SNES), I haven't really played a lot of the other ports they talk about (or the original games either, in some cases). I vaguely remember the arcade Ikari Warriors being cool, but the only experience I have of the NES version is the AVGN video about it.