No, they basically don't exist. I'm United Mileage Plus Silver and have never seen an upgrade (although now I get 'free' Economy Plus which just adds a few inches of legroom to the terrible experience). I've had friends put in for first class upgrades for me a number of times and never once seen one.

A "normal" person who doesn't rack up tens of thousands of miles a year will absolutely never see an upgrade.