I find some squash and watermelons do not yield a lot of mature fruit for the space they take up. It depends on where you are. Pumpkins, watermelons, cantaloupes, and butternut squash, have very long vines but yield only a handful of mature fruit for me. On the other hand zucchini, scallop and crookneck squash, and gourds give me dozens of fruit.
Potatoes are not a staple for me and relatively cheap to buy so I do not grow them. Celery, I cannot grow. I do grow cutting cerlery and it lasts about two years. Carrots I can and have grown. But I cannot grow enough carrots, onions, or garlic to keep me supplied all year in my small space and they are relatively cheap to buy, so I plant things that I like to eat that are relatively expensive to buy but easy for me to grow.
I grow green onions, eggplant, hot peppers. Many herbs mostly in pots: bay leaves, thyme, sage, basil (in summer), lemon grass, and many kinds of citrus trees in pots.
In the cooler weather I grow beets, lettuce, kale, chard, green onions, parsley. peas and fennel. If I still have room I will grow carrots.
As the weather warms, cucumber, tomato, eggplant, beans, squash/gourd and hot peppers.