SanDisk Extreme Pro is one of the best, in my opinion, they excel in IOPS for small random read and write which is especially important when using it in a computer like Steam Deck or Raspberry Pi. A lot of other SD cards are optimized for cameras where it is writing a lot of sequential data, but are slower in small reads and writes.
I had a 256GB phone and after 1 year had used less than half the space, without ever deleting anything, so when i upgraded this time I saved money and got the 128GB model. I sync my photos/videos to my NAS so can purge those from my phone at any time to save space. That’s really the only thing that takes up any significant storage.