Looking at Brexit again about 25 years after it was enacted, so that would be 2045 by my reckoning, doesn't seem unreasonable at all to me. Clearly you can't be in/out/in/out with that sort of thing but 1973-2020 in was 47 years in so we'd need to spend a long time out to match that IMO. I think I originally said the exact same 47 years but I must be going soft.
On IndyRef2 I think the case is much clearer. Westminster simply isn't allowing SNP MPs to give effect to the wishes of voters in Scotland. That's the way the Westminster system is, since a party with a max number of MPs in the low 60s is never going to govern on it's own. However the connivance of the 2 largest parties and the Speaker to deny the SNP the opportunity of a vote when they controlled house business last week, was shameful.
I don't think there needs to be an IndyRef2 next month, nor even necessarily quickly following the next GE. The case for one could be strengthened or weakened by the electoral performance of the SNP. A 4th successive GE where the SNP win the most votes and the most seats in Scotland would powerfuly make the case that the current system is failing Scottish people if, as I expect, they form no part in the government.
I remember feeling very differently about this in 2015 when it looked that a party that wants to the breakup of the UK would possibly be in coalition government (with Labour) and I hated the thought of that.
3 GEs later by 2024! if the message is the same this time, from voters in Scotland, then it's high time they were listened to IMO.