Yes

From less than 1 kilobyte to over 1 Gigabytes

I started with a 32GB which is plenty for Arcade Games ... as soon as you add consoles, well, i got a 64GB card which lasted a month before i got a RPI4 and was able to add even More Consoles .. picked up a 128GB card. Will see how long that lasts ;) ... prob end up using a hard drive for game next and just use a smaller SD Card for the Retropie OS

TLDR: SD Card Size will Depend on what systems/consoles you intend on playing.

Oh, and if you compress you roms/images (ie. i have compressed all my PS1 games to PBP format and Dreamcast/3DO/Sega Saturn games to CHD format ... saves a TON of space !)

Yeah, should be fine .. all my cards a Sandisk