I would say Command & Conquer Red Alert, but that has mining and other gathering (though you're never really waiting for it to build your next building, as its mostly there to make it so that your army of armored bears doesn't get built in two seconds) as well as it's about as realistic as Pea Wea's playhouse. You can get a laugh out of the outdated and cheesy as hell FMV (Full Motion Video, which is that live action stuff that flooded the market in the lat eighties and early nineties) though. Especially the ones with Stalin.
Command & Conquer 3 is a little better, and it even is pretty realistic, if still a bit silly. Such as there's aliens (called Scrin) that look both cool, and like they belong on an Ed Wood movie at the same time, as well as the main object of interest is a giant green crystal that is infesting the planet (kind of like a cancer, or herpes if you want to be funny) called Tiberium, and we get some freaking awesome techno-bable out of it. There is still harvesting (which is done from the Tiberium), but you never have to scavenge, and you get it fast enough that you're never really waiting for it to arrive.