I am increasingly of the opinion that referendums in general are a bad idea in a parliamentary democracy. MPs and MSPs are not delegates, they're representatives, and when the best interests of their constituents clash with a referendum result it undermines their ability to actually represent their constituents. As has been shown by Brexit.
If the system changes to more direct democracy generally, then that's a different matter. However, i have no idea what the result of issues such as the death penalty, foreign aid budgets, legal aid, etc. would be, but I fear they might be very nasty.