"Normal" fruiting style courgettes described as climbing tend to be straggly growers and need tying onto a support, but ones like MoS mentioned, Tromboncino types have tendrils and do they job themselves. The other good thing about them is that any you miss ripen rather nicely into fruits you can store
Plus of course they look really good!!