Lougheed is fair, I would generally consider that part of the Burquitlam span. It's awkwardly spread out with the mall itself sitting in a sea of parking lots, that doesn't tend to help build a good neighborhood but it is thriving, possibly due to being within short reach of the box stores out United/Woolridge.
Sorry, I was incorrect about Metrotown, it is a pretty nice city center but the rest of Burnaby suffers from west-coast suburb development, areas are either residential, res+light commerce or res+employers, it's hard to find a neighborhood where you can live, work and shop unless you're working in retail, and IMO a neighborhood that can't supply all three is going to fade away to pure residential in time due to NIMBYism.
Population density does play a huge part, which forces inadequate access to skytrains and so on, but you can still catch a bus, then use the same fare to get on the seabus, then the skytrain, then more buses, and maybe bring your bike so you can get that last mile in.
It's a public service and one that society should be happy to invest in. Governments that balance the books on public transit with accountants alone are acting against the societal good.
Cities built before cars were as widespread as they are now had to put a lot more effort into making themselves livable and providing sane ways to move about the city locally (for daily needs) and regionally (for occasional needs)
I am aware that the nearest city (New Westminster) is developing pretty actively, but there is a deadzone in between the two (Burnaby) that seems to have draconian NIMBY zoning laws. Generally speaking, Vancouver's housing crisis is pretty amazingly interesting and probably is more a result of the incredibly poor transit here[2] than anything else.
[1] There may be some single family units remaining in the Denman neighborhood and there are some remaining in Strathcona (near east van.) as well as lots in Kitsilano and the south shore in general, but both of these areas are generally considered outside of the downtown core.
[2] Oh yea, we have driverless trains, woo... but there are only three transit lines none of which connect to either of our major universities and poor management of the system has left the lines overcapacity.