I've actually put in a lot of time and effort into finding foundations that match me, and to be honest, yes it was kind of difficult, although partially because of issues besides my skin shade. I'm not going to say there aren't options, because of course there are, but if I'm being blunt, it's a little frustrating, especially since it seems like it's very popular to be very snarky and dismissive about this topic. Once you get to, say, MAC shade 05 or below, there really isn't much of a selection, and I feel like undertone and formula is almost as important as skin shade. Finding your combination of right shade + right undertone + right formula for can make it tricky.
On the other hand, I can understand the frustration a lot of people seem to have re: the pale skin competition game. Hell, it's something I noticed my friend trying to play with me all the way back in 2005. It is kind of ridiculous and not at all helped by the hyperbole that seems popular among "contestants" (paper-white, milk bottle white, fishbelly, ghost, etc.).
For the record, if you're MAC 05 or below, I'd recommend looking into custom blending (Prescriptives can do it, and they can use white as a base if you ask them although it's considered a special order and there might be coverage issues), or "theatrical" makeup companies like Graftobian or Kett. I know Kett makes an airbrush foundation that runs pretty light, and Graftobian has their Ultra-Lites shades in both a creme foundation and an airbrush foundation. MUFE also released a new shade called Y205 that's pretty light too if you don't skew too far from neutral.