Well that is the story that those who don't want to see Scottish Independence will push. It's a colonial argument.
It's a very narrow view of wealth flows, looking at the bigger picture then more flows back the other way.
e.g. See the example of Strathclyde Police Training and Recruitment Centre here:
https://www.taxresearch.org.uk/Blog/2019/08/16/the-burden-of...