Just don't stay anywhere near Hastings and Main (or east of there).....
I absolutely love the Fairmont Vancouver Airport.....but you want downtown....and when my ex-girlfriend lived in Vancouver we stayed in here apt. off of False Creek, so I can't help you there....
But seriously, unless you are an IV Drug user, stay away from Hastings and Main and points east (at least until you get to Burnaby!).
- HF