"Rodney Dangerfield" city of Canada? Don't see any CA version of Cleveland on the list. That said, through folklore, Edmonton, Winnipeg, and Hamilton always seem to at least "touch" that bar, however unfair that may be. Sorry guys - all great towns BTW.
In BC, Surrey, more particularly northern Surrey or its Whalley district has always been the butt of BC jokes. To a certain extent, New Westminster, BC as well.
The ultimate "Rodney Dangerfield" town in BC has gotta be Spuzzum, BC - situate along Hwy 1 in the Fraser Canyon. Spuzzum has always been the butt of BC media jokes - mine as well. Along both directions of Hwy 1, "You Are Leaving Spuzzum, BC" highway signs were once extant.
Spuzzum is also known to be "beyond Hope [BC] and the locale of a legendary "Spuzzum Institute of Technology".
Guess the jokes got so bad that the current remaining population indicates same - ~ 0 from my understanding.