Depends, there is a huge variety in watermelons. Theres big, medium and small to start. White , yellow, orange, pink or red flesh. Seeded or Seedless? visual appearance. The only one on my grow list that I could not recommend is Matador. http://s294.photobucket.com/albums/mm92/farmerdill/Watermelon/ For starters, the OP Crimson Sweet (22 lb class) is excellent. Lots of hybrid versions but Raspa gets the majority of good reviews. Want a smaller melon, Mickylee (12 lb class) I prefer it to Sugar Baby which is ok in this class. Yellow Flesh Desert King. Orangeflesh Tendersweet, White flesh Cream of Saskatchewan. Small hybrid yellow Yellow Doll
For pumpkin pies, I prefer Cushaws or Winter squash Hubbards are very tasty in pies.
Jack o Lanterns. Lots of choices depending on size wanted. or whether you want orange or white. Jack o Lantern as mentioned by juhur7 is a good op, Howden and Connecticut Field for a larger choice. Lumina or New Moon for white. If powdery mildew is a problem Dependable
My favorite variety for making pumpkin pie (and pumpkin bread) is Waltham Butternut (squash). If you've ever bought pumpkin in a can, there's a pretty good chance it was butternut squash instead, or another similar squash.
Why do I like it better? Better productivity with fewer problems, the skins are a lot easier to remove, it's less stringy, and, IMO, butternut has more flavor than a typical pie pumpkin. Once the pulp has been cooked and the evidence discarded, no one can tell. :)
Non GMO Crimson Sweet, Sugar Baby, and I save seeds from Hermiston melons, and replant, all three do well. My season is not quite long enough for cantalopes but I get a few every year. This year, I bought a yellow watermelon from Baker Seeds which I have never tried before.
I cannot grow butternuts here, season not long enough, but I do well with Delicatas, and Sweet Meats.
nancynursez637, try Minnesota Midget for melons. It's supposed to be 65 days but they produce for me in about 80. Each 3-4' vine produces about 2 4-5" round melons, but the vines are so small you can plant lots of them.
You're right, butternuts take a long time to ripen. So do pumpkins. Perhaps the OP needs some ideas for short season varieties?
I grow New Queen (a small yellow watermelon) and Little Baby Flower (a small red). Both are sweet, but the yellow is the sweeter of the two. I prefer small ones, due to small family and not a lot of refrigerator space. For pie pumpkins, I've only tried Baby Pam, which are fine.