WTF Is Upsampling? Why More Digital Audio Samples Don’t Always Mean Better Sound

Does upsampling in digital audio actually improve DAC performance, or just make lower quality files look like high resolution audio?