Those student buildings are pretty bad, yes.
I realized I missed the most obvious one for St. John's RE: the neighbourhood everyone makes fun of.
As soon as someone mentioned Transcona for Winnipeg, I thought, "Oh, THAT'S right! It is Transcona. Which means ours is Shea Heights".
Shea Heights is an interesting neighbourhood of St. John's.
It's high atop the Southside Hills opposite from downtown and has, by far, the best views in the city. But has traditionally been a slum/libertarian utopia - far removed from most government services and intrusions.
Still today it looks like most of the houses are fixed-up shacks and most of the streets are just paved walking trails. There are lots of new homes going up to take advantage of the view (and they're starting to dominate the area, actually) - but, like the rural prairies, you can still find homes with cars in the yards, junk outside their garages, etc. It doesn't have the same pristine, prideful appearance as most of St. John's. It's far dirtier, for example, than any of the poorest neighbourhoods in the city proper.
It has a reputation for being unwelcoming to outsiders, backwards in political thought and fashion/style, rowdy, home to criminals and delinquents, etc.
It's also, despite its proximity to downtown, completely separated from it. There's the harbour, the industrial port, and the Waterford River between it and Water Street.
EDIT: It's easy to find thousands of pictures of the view of St. John's FROM Shea Heights, but very hard to find any pictures OF Shea Heights. Here's a view of the newer parts of it from somewhere in the west end of St. John's:
Untitled by
ncbeets, on Flickr