As of today standard SD cards can be had in a 128GB size. MicroSD's up to 64GB. One can assume that down the road their capacities will go up....to a point maybe 1-2T, but the price goes up exponentially as they get bigger. Other than that they both work the same, the Standard is just 4X bigger.
Full size goes to 256. On Amazon right now, I can get a 64GB SD for $40, or a micro for $60+. Or 128GB full size SD for $95 from Kingston. So you get more for less, I say again, with full size SD.