I'd recommend a micro-SD card that is specifically designed for dashcam operation. They are practically immune to heat, cold, shock issues, and are designed to be continually overwritten. They also are high performance at reading and writing, and only require a minimum of power. Many are guranteed for 10+ years. Most have the word endurance in their name. Both Samsung and Sandisk offer these as do other manufacturers. I have the
256GB Sandisk High Endurance card (link photo only showing 32GB for some reason):
Designed to record for up to 20,000 hours1, the SanDisk® High Endurance microSD™ card gives you the peace of mind that your dash cam, home monitoring or security system will capture crucial footage when it happens, recording and re-recording worry-free. It’s built tough too—ready to record in...
shop.westerndigital.com
This will be the smallest option. The microSD card with a USB adaper is as small as the USB adapter. I have the MobileMate USB 3.0 reader:
The MobileMate® USB 3.0 microSD™ card reader is the easy way to quickly transfer content from your camera or drone’s memory card. This compact and durable reader requires no downloads or additional software and is compatible with USB 3.0 and backwards-compatible with USB 2.0. And, with transfer...
shop.westerndigital.com
As you can see, this entire storage solution is so small it is about the same size as the USB plug. Unless you are looking for it, it is essentially hidden from view. I have had this almost a year without any issues.