mesh, I certainly can't give an answer to specific Vancouver hotels, but in my experience with a lot of low to mid quality hotels in Canada, the U.S, numerous countries in Europe etc, it has been the exception when I've been specifically told it is not allowed. Numerous times, I have also been able to talk my way into letting places let me bring my bike in.
I suspect that how one presents oneself to the staff can be a factor, ie responsible looking, not arriving with a filthy muddy, greasy looking bike (not your case I realize with it boxed).
I've even had no problems at a Premiere Inn near Glasgow with bringing my bike to the room, if that gives you a familiar reference.
Obviously, be very conscientious and respectful and keep the drivetrain side against the wall, so away from bed, towels etc, and be careful the bike doesnt fall over and leave a mark on the wall--pretty much common sense stuff.