Purely anecdotal, but my friends who are Man City fans say they genuinely preferred it when they were shit. I imagine nostalgia is a big part of it, but cheaper tickets, a core fanbase, and (most of all) a sense of feeling closer to the club are the things they talk about missing.
The upsides...