Awesome but unnecessary IMO - convenience and not price (at that of a regular fare) is going to be the deciding factor for using transit to access the Ottawa Station.
Personally I think it would be nice to have some kind of weather-proof connection to Tremblay Station - the current proposal suggests a marginally covered route that is otherwise open to the elements.
AoD
To downtown, it would be about a $10 cab fare, maybe a bit more. For 2 people, OC Transpo cash fare would be $6.50. Most hotels in downtown are either in the Market area (Westin, Les Suites, etc), or along the Queen corridor (+/- a block). With paying either way, it's a bit of a toss-up, but throw in that fare for free, and it may tip the scales.
I should specify that I'm talking specifically to and from Downtown Ottawa, not any other points. This is just to make up for the fact that the Via station isn't downtown, like it is in pretty much every other major Canadian city.