It wouldn’t be very long though: it can be a microSD, microSDHC, or a microSDXC. Ideally it needs to be UHS-I U3 or preferably V60 or higher. Just get the biggest and fastest you afford, and make sure your Switch is fully up to date.
When it comes to SD cards, “bang for bucks” needs further clarification: does bang mean capacity? Does bang mean speed? Does bang mean capacity and speed together? And then what about where the bang is to be applied: in a console, a phone, a camera, a drone? All these different situations will have a different set of criteria with which to judge the best bang for the bucks.