I was hearing the same things about the draft a couple of years back. Will it bring some money into the local economy, sure but I really can't imagine it's significant. Most people at the game will be from Ottawa. As far as showcasing Ottawa, yes people will watch the game and I'm sure the networks will put on some Ottawa filler pieces.
If Ottawa's profile means something to you then yes this can't hurt but I just don't think it does a whole lot. I think most people have an understanding about what Ottawa is about. That's just my opinion.