Yes, agree that the free upgrade possibilities for a Gold are quite low, so maybe if you can prepare yourself mentally to spend a little money for reasonably priced upgrades at check-in, you might be better off.

Suggest splitting the records as discussed, and checking in so that the person(s) you most want to have an upgrade are first to check in. That way if there are only a few upgrade offers the first to check in would get it first.