I rarely grow big squashes because there's only me to feed.
The High-sugar range which includes Celebration, Harlequin, Festival and Sweet Lightning ( all have similar markings and I find it hard to tell the difference between them
). They are all small, fruitful, pretty and lush, hard to beat for taste IMO
Uchiki Kuri is also another good one.
The trombone squash Tromba d'Albegna can be used small like a courgette in summer, but if you leave them to mature, after storage they become much sweeter, with quite a firm texture. It has an 'interesting' shape rather than look pretty though. I like these more each year I've grown them up a tripod with sweetpeas.
Last year wasn't good but this was my harvest
Thelma Sanders is the pretty cream one, it's the most reliable and prolific of the ones I grow but is less sweet than the others.