Advice on obtaining residency to move to Menorca as a UK citizen

I am a photographer looking to move to Menorca from the UK on a permanent basis. I am looking for properties in and around Ciutadella. I have found a number of interesting places, but I am having difficulty working out how I can stay longer than the 90 days in 180 since bloody Brexit!!

I have spoken to a few lawyers in Menorca, and Spanish firms with UK offices. I have explored the Non Lucrative Visa, and Digital Nomad Visa. The non lucrative could work if I want to fully retire, but I'm only 60 years old, so would like at least the option to carry out occasional work in the UK, but as far as I can discern I can only receive a passive income. The Digital Nomad wouldn't work for me because, as a freelance photographer, (for over thirty five years), but I can't show guaranteed future work, as I receive commissions on an ad hoc basis.

The Golden visa is about to be withdrawn, so it's unlikely I could get that through before I find and purchase a property. Then there is the option of investing €500k in Spain, but I need advice as to where I would have to invest, for how long, and the tax implications.

I absolutely love Menorca, and know it's by far and away the best place for me to move to, but it seems every option I look at is either not relevant, or has unknowns.

Does anyone here know of anyone that has managed this or could reliably advise as to my best course of action?