Wales' 2026 Commonwealth Games campaign labelled a success after they won 31 medals in Glasgow, with nine gold, 10 silver and 12 bronze medals.