you can usually get through but count on having to deal with bs, going into immigration/customs and getting your car searched. you're better off bringing a passport or birth certificate if you've got one.
as for staying in vancouver, downtown is definitely not cheap. there is a hostel downtown. and another out in jericho. and there are much more affordable motels on the other side of lion's gate bridge.