Can you give us better lists of games that fall into both your good and bad categories?
My hot-take answer was going to be that it's all nostalgia and there haven't really been any good ones (at least that I ever was aware of). Given your edit on nostalgia, maybe it's not nostalgia for an individual game or games, but rather a a time and a style?