Locals say the impact of the multi-million-pound event has been "terrific" for the area.