I second the Monistat anti-chafing gel. I keep an eye on drugstore.com or vitacost.com for good deals and buy a few at a time (using ebates of course!)
It lasts forever and, for me, works great for inner thighs when I'm wearing a skirt or dress.
As for the coverage - I'm stumped there. I can't find the combination of good coverage AND matches skin tone AND lasts more than an hour or so. Oh, AND doesn't make my skin issues worse. Sigh.