Brian Wilson documents how a grandiose SNP plan came to grief, leaving behind wasted years, wasted money and lost opportunities