Downtown Vancouver is rather limited, Red Lion, Hilton, Econo Lodge and Comfort Inn are the only things downtown.
The next closest would be Hayden Island across the river, there is usually alot of bridge traffic, but being a holiday weekend, hopefully it wont be too bad.
After that there are some hotels on Hwy 99, however some are pretty rough if you dont go with a chain.
There are several hotels down by the Mall area by I-205, getting pretty far out there
tid