I don't agree, Crow. I think a small majority in either direction would just stir up those who have lost the vote, whichever way they voted.
The "Yes" contingent would renew their efforts to convert the doubters so that in a generation or so they can renew the campaign for another shot at goal. The "No" contingent would feel that the Union is still unwelcome in Scotland, despite the narrow victory.
Either way, businesses who are considering locating in Scotland would find the continued ambiguity a threat to the stability of their investment.
A big majority is needed, to show that whichever way the vote has gone, most of the population will be behind it, and will work to make a success of that decision. Then we can put the controversy into the past, and concentrate on the success and prosperity of the country.