I would say the difference in good touristy and bad is that good touristy sites are places that have a real history to them - the Acropolis, the Colisseum, Tower of London, etc. Bad touristy places are those that are fake - hula shows produced for tourists, the previously mentioned "cable" cars that aren't on cables, wax museums, theme restaurants and so on.