I bought an Apple TV 4K recently, knowing this limitation (having researched before), because I thought the 24.000 fps content would be minimal, but I've just found out it's a not-insignificant amount, at least on Netflix. A lot of the European films and TV shows are, like Dark, and even movies like Bird Box, like someone else mentioned earlier. Other stuff I just saw includes the Korean films Burning and Train to Busan, and the new Ultraman series. You can check easily what framerate the content is on the browsers or the Windows 10 app by pressing Ctrl+Shift+Alt+D.
As far as I found out, the Shield TV does have support for refresh rate switching, but the apps need to support it, and Netflix doesn't. Apparently Netflix only supports that on the Apple TV and Roku.
The semi-good news is that I came to an Apple TV from a Roku Ultra (2016) because it has the exact opposite issue, it can only switch to 24.000, and can't do 23.976. The weird thing is that it does 59.94 but not 60.000 fps. So maybe you can use a Roku if you have one for 24.000 content.
As far as I know, there's no streaming device that can do Netflix and use both refresh rates.