No, not ever in normal road riding.
The only time you would shift weight in this manner is at low speeds on U-Turns where counter steering does not come into play and you want to counter balance some weight during a full lock or close to full lock U-Turn. You get better benefits by practicing better throttle, rear brake and vision disciplines however.