The Commonwealth Games will take place in 2026 after Glasgow stepped in to host, but the stripped-back event has left some celebrating and others disappointed.