As to the post failure financial effect, that was mainly on a bunch of rich folks. Scotland per-se was not in any financial distress after the failure of the scheme, as it was private individuals, not the state which had invested.
Have a read of this piece, which covers a lot of the history around the failure of the Darien Scheme.
https://wingsoverscotland.com/weekend-essay-skintland-britna...