That's a lovely spot for it.
With me, I would be thinking for quite a long time about a situation like that, before choosing plants. You have a bunch of stuff going on there.
I grew up on the West cost of Scotland, so I have some idea of what your climate is like, but it's a bit different from mine still. I live down south now, so again, hugely different.
Maybe I could try to figure it out a bit?
If you are in Edinburgh, then you are going to have:
- enough rain to sustain life, but not constant bucketing rain. That's good.
It is good, because drought makes it really hard to germinate and sustain stuff, and saturated ground is also a problem. Having tons of rain like in Glasgow also means a lot of cloud which reduces your hours of sunshine, so being in Edinburgh is good in many ways. You are getting enough rain to help seeds germinate and keep plants going but not enough to cause things to rot probably. That's good.
-
you're pretty likely to get sub-zero temperatures each winter, so you want to have hardy stuff, or stuff you can bring indoors or into a greenhouse or similar when it's cold.
-
Your back garden is north facing so in the shadow of the house it's going to be colder and darker, so in a spot like that, you're probably looking at growing a bunch of shade-loving plants like ferns, and they could be really really really good ones because you have perfect conditions.
-
Your front garden is south facing so you have a sun trap there.
-
The really big deal in your situation is how much of your year you are getting temperatures above 14C. It is above 14C that plants really start to grow. That's when people have to start mowing their lawns.
I would guess that in a good year you are above 14C from about the start of June to the end of August. Would that be right? That's a growing period of 8 weeks. In a dud year, which I know does happen, things might not get really above 15 or 20 for long. I had a bunch of years like that growing up. It's a good idea to plan for years like that, so you still have a beautiful summer garden. In those years, you're going to be really happy to have a few plants that thrive like that. That might be things like Desfontainia spinosa. Maybe a lovely paeony or two.
If you want nice annuals, you would have a much better chance if you could start them indoors or under glass. Is that a possibility? Or you can buy little plants pre-grown from places like Thompson and Morgan, and put them in already at flowering size when the frosts are finished (1st June probably where you are.).
I would guess you could grow really cracking roses in your front garden if you don't get deer coming along to eat them.
Does that help a bit as a start?
Have you tried watching the Beechgrove Garden. They are amazing at teaching the real skill and science of gardening.
I live down south now and we have tons of sun but no rain. A dud year for us is one where so little rain falls that the lawn turns completely brown and cracks. We have quite a lot of those. About three years ago, our heatwave hit 42C and I lost a lot of plants because they just got toasted. The conditions are so different in different parts of the British Isles. I find it really exciting trying to figure them out and work out which plants will love a certain area.
Thank you for giving us this puzzle to work out.