Sparkling A couple of mistakes in your post.
The quite a large amount of money you refer to is the amount that would have been spent from Wesrminster in Scotland on the things which are now devolved and administered from Holyrood, proportionately to the population. In return quite a large amount is paid into Westminster coffers from the taxes of Scottish people. That means that Scottish taxes pay for Scottish devolved expenses.
The Scottish Government estimates that around £65 billion-£66 billion of revenues were raised in Scotland in 2019/20, equivalent to approximately £11,940-£12,060 per head.
Spend per head by region, 2019-20
North East £10,285
North West £10,204
Yorkshire and the Humber £9,401
East Midlands £8,879
West Midlands £9,570
East £8,991
London £10,835
South East £8,919
South West £9,193
England (average) £9,604
Scotland £11,566
Wales £10,929
Northern Ireland £11,987
UK (average) £9,895
As for wanting a "Queen Nicola!" What a weird idea. I have never heard even a whisper of anything of the sort, and I can't imagine any Scot wanting to turn her into any such thing.