Sir Chris Hoy has fond memories of the Commonwealth Games and is convinced the Glasgow event, which starts next week, will be a "massive success", despite a scaled-down format.