I just bought a 512GB Samsung Evo Plus SD card, and for giggles I tried it in my N900 (because that was known to take 64GB just fine).

Surprisingly, it takes it and even shows under Linux! I had to use USB Mass Storage because the card was formatted under exFAT from the factory and as we know that doesn't exist under Linux at the time.