It depends what you mean by 'look good'. Immature plants generally look just that - immature. There are some that are more awkward than others (Abies concolor comes to mind) and some that look better (Sequoia sempervirens generally looks pretty nice even when very young). Wander around nurseries and see what you find. Many #2 and #3 plants look very nice, and they are usually not very old.

Yeah, using your
words, young conifers in #2 or #3 containers that look good. So that one can enjoy
them right away as well as enjoy them as they grow and become even better looking.

There is a common
complaint of never having enough selection in one's own area, so suggestions
from the net are welcome!

Edit: Sometimes, it will be the subsequent guy who admires our plantings.

I collect dwarf conifers and purchase almost all of mine as 1G sizes. They all look great from that age onward, especially the Chamaecyparis and Cryptomerias I favor.

Retailers would have a hard time making sales if young plants looked decidedly "ugly duckling" like :-) IME, it is more often the more mature specimens in gardens that tend to develop funky looks due to improper planting and aftercare practices, ill-advised pruning or disease and pest issues. These are seldom of concern with young nursery plants.

I have just discovered the obvious: searching
for 'Gallery' on the GW Conifers forum yields a Cedrus gallery, Abies pinsapo
gallery, Picea omorika gallery, and numerous others. Most galleries are from
2010 to 2012, showing conifers at various ages from seedling to mature, many old photos don't show up anymore, but there are more than enough left to enjoy...

Picea glauca 'pendula' look nice young if they are full of green branches.