Put simply, you'd use it if you urgently, desperately needed to get the gear up; for example, to get over
that big lump of rock when you've suffered a failed donk and the gear likes letting it all hang loose.
Any other situation, yes, you'd probably wander around to the other end and place the wheels nicely on the hard bit of tarmac they thoughtfully placed there for such eventualities.
I once used it in the sim when still on the runway. (The gear lever lock works quite nicely with weight on wheels!
). We had an engine out, but I had convinced myself we were airborne, so I hit the override. The gear came up - and we carried on flying, at about 4' QFE! Gradually climbed away - afterwards the TC said "I REALLY don't know how you pulled that one off!".
Nor did we.