Ok, both 2023 M2 MacBook Air models come with Thunderbolt/USB 4 ports. That would mean that to get the best performance from an external drive, you will want a drive that uses similar ports.
However, USB 4 being the latest technology, comes at a higher price point. You can easily get great performance with USB 3 or USB 3.2 drives.
As such, I suggest you start your search at OWC as they have numerous external drive options. Disclaimer: I do not work for OWC, but have been a customer of theirs for years and have never had any issues with their offerings.
Ref: https://www.owc.com/solutions/external-drives
Also, one thing to consider. If you decide to equip your new Mac with the smallest internal drive, you should consider getting more RAM memory. The reason is that when you attempt to run multiple apps simultaneously, if there isn't a sufficient amount or RAM, those apps will be swapped out to the internal drive. This will affect the laptop's overall performance. It will also "wear out" the internal drive quicker. (SSDs have a limit to the number of writes to them.)
Without the additional RAM, which you cannot add later, you would be limited to running fewer apps simultaneously. Not a real issue, if you only run a few at a time or run ones that are not memory intensive.