If budget isn't an issue, consider the Fairmont Pacific Rim for your Vancouver stay. The palatial suites have incredibly scenic views of the harbour and surrounding mountains. Location-wise, you're close to most downtown attractions and there is a SkyTrain station nearby.