I don't have statistics, but I believe the more common scenario is that the company gets acquired, and the return on investment is not the 10x or 1000x or 1000000x the VCs hoped for, so they recoup their original investment. Leaving the engineers with options worth nothing.
I view liquidation preferences as VCs offloading risk to employees because they can.