I think the problems that exist with sport in Scotland are that every possible sport wants their share of the available funding and that many sports that receive the funding are poorly organised or not really suitable for our climate.
My solution:
1. Select a few sports that don't require to be played outside, don't require expensive equipment, ideally can be played in a gym hall and are more suited to our national "type".
2. Set up 5 centres for excellence in these sports through the country, all overseen by one organisation per sport.
3. Provide targeted funding for these sports, even if it is to the detriment of more popular sports.
If we do want to improvement in football we need to have our children playing on good surfaces during the school summer holidays, instead of on quagmires during winter weekends when they're still recovering from a week at school.