When I was Silver, I'd rarely get an upgrade at the window, but would get it upon check-in about half the time. With Gold, I get it at the window every time. (Excepting the occasional 5pm BOS -> DCA flight, which has a lot of FF).