You should look at other people's gardens and open gardens such as National Trust and really analyse why things look good or not so good. My style is to echo what happens in the wild - for instance you don't see bluebells growing in a row.
I think he's trolling, jo47. We've got a troll at the bottom of our garden as well.
There is an issue with preserving the integrity of the damp course, which appears to be at the top of the white part of the wall on the left side (half way up the steps on the right).
Dig out as many nettles as you can, following the runners as far as possible, then next spring dig the new shoots out again, then later treat any further regrowth with glyphosate when it's got plenty of leaves.
A well-constructed trellis (really stout posts and good quality trellis) should withstand the wind and create a baffle. You could choose whatever density of trellis suits your requirement to let light through and choose some hardy climbers to break up the appearance. Too many dense climbers would increase the wind resistance and compromise the stability of the panels.
It is autumn here, so I'd start now. You need to make a start before the weeds die back and disappear. There's a bit of hard work, but that's why we have gardens!
Search 'glass balustrades' and you will find a lot of ideas that might be suitable. We have friends who have these on first floor decks and they are pretty good, but not as cheap as a plant.
Any chance of a pic?
I can't see what makes this garden 'unusable'.