This hotel backs onto a very busy bridge and highway and is in between two flight paths for YVR. However, there are only rooms on the West side of the building so the wall and hallway do a very good job handling the traffic noise. You will hear the rumble of the jets (although there is a night curfew) but they do not pass directly overhead. This is something you will get anywhere in Richmond.
Overall the hotel represents great value with decent parking and breakfast included. There is not much within walking distance but there is a shuttle to the airport. If you want to explore you will need a car.