I can only speak for myself. I've been doing this for 4 years, so I'm not a seasoned pro.
My default destination is a 10 g "squat" pot. Often I use smaller pots, but only if I've runout of 10s. I find the 10's relatively easy to move. When the planting medium is dry, I can pick them up and carry them.
For the better prospects, I use 13-15 g pots. To move these, I need a hand truck.
For the best few, I use 25 g pots, if I can find them.
All pots are SIPped.
So far, I've been mainly up-potting. But I expect to prune roots and refresh medium every 2 years (10 g) to 3 years (15-25 g).
If you take a look at drivewayfarmer's pix on the thread where he is offering plants for sale, you can see what is possible.