I got my Libby glasses for upstairs at Fred Meyer (Kroger). That’s because they tend to stand up better to guests than more fragile glasses. Avoid the large balloon glasses, which break easily.
So I purchased 8 of everything, for a place that has a max of 6 guests, partly because the glasses came in 4 packs.
Stemmed wine glasses
Pint beer glasses (we have 4 local breweries that sell souvenir glasses, but folks kept trying to buy my local logo glasses)
Juice glasses (6 oz)
You may want something more high end if your place is more upscale, but you want durability over beauty. OTOH, I have found beautiful Mexican crystal at throwaway prices at garage sales and thrift stores.