I've yet to be disappointed by Produttori. Speaking of lower end bottlings from good producers - this Barbera from Giacomo Conterno is excellent - not quite a $20 bargain (and expensive for a Barbera) but so well made and drinkable for something so young...
A propos the Nebbiolo conversation above, that Produttori Langhe @ ~$20 is a nice example of how accessible a young Nebbiolo can be in the right hands. I've had it a few times and it needs a rough pour and swirl to get it to open up but I think it is a nice pizza or grilled meat wine.
Red or rose Sancerre is always 100% pinot and they're generally not easy to find as the quantities are small.
I've had pretty good ones from Vacheron and from Mellot. There's another Reverdy (not Hippolyte that makes a great white) which is supposed to be very good for red but I've never had it (Pascal and Nicolas Reverdy).
Not the best Bourgueil? I would agree, but I don't think that it aspires to greatness - it's a nice light red and drunk a bit cool in the summer with something off the grill and shared with friends it is delicious.
Sounds perfect for this weather. I've enjoyed a Loire valley pinot d'aunis from Clos Roche Blanche which has many of the characteristics you describe. Last night, late into the warm evening we enjoyed our favorite rose from Tempier.