You're apparently looking for a physical legacy ... (which is indeed there if you look for it.)
But more importantly from my perspective is to acknowledge the amazing legacy left in the form of folks memories and attitudes.
Ask any Commonwealth Games volunteer (for example) about their experience, and almost to a tee they'll tell you if was one of the best times of their life, and that they'd do it again in a heartbeat.
But as Shoeflack pointed out, those physical remnants and legacies that you seek are around as well ... with the touchstone for the '94 games being the still flourishing Saanich Commonwealth Place.
We here on the left coast changed in a most positive way, and for good as a result of EXPO86, The Commonwealth Games '94, and the Vancouver Winter Olympics ... sometimes the real legacy of a special event isn't seen simply in bricks and mortar.
The people who could afford tickets and the elite who got them for free have great memories. The rest just got the bill.