I think your first step is to organize it into piles: one for containers, I see some items that could be used for trellises. Get your piles organized so you can make better sense with what you have to work with. I wouldn’t recommend succulents in your climate. But would suggest looking into short rooted plants for the really small containers. Perhaps sedum. The Old Farmers Almanac has suggestions for container gardening. Right now it’s a bit chaotic but some conscious sorting will reveal some interesting resources.
