Against a tough economic backdrop, it's no surprise there is little appetite to host a major sporting event such as the Commonwealth Games