I personally only use SD as it's easier, but SSD is obviously faster but unlikely it would make any difference compared to Micro SD unless the card is really slow to begin with. The HDD advantage is the amount of NSPs you can install not so much the speed. I know Switch is limited there as different SD card speeds don't make any difference on Switch.