I know mpc-hc can do it, and people say Media Portal can too, but I've never checked. These two are really examples of the way it *should* be done, that it, the video player itself is obviously aware of the frame-rate and adjusts the refresh rate accordingly (assuming you're running full screen).
The survey that TMT put out recently suggests they're thinking about it too.
Reclock can help, but it's solution is far from ideal and requires a fair bit of luck and/or black magic to get working, partly because of its reliance on Powerstrip to manage the actual refresh rate change. This is because if you change the refresh rate while a video player is already running many of them don't respond well to the event, and often crash or black screen. Powerstrip can make the change without generating an event, but it's not compatible with a lot of modern cards these days.
It can also sometimes work with Catalyst/nVideo profiles, but again it's down to pot luck as to whether your video player will handle the refresh rate change nicely. With a profile change, you can be sure it'll be aware of the event - whether it handles it nicely is another matter entirely.
Reclock can however, also help you avoid having to change to 24fps at all, as it can speed up the video (with correct audio pitch adjustment) to 25fps, meaning a single refresh rate can be used for the majority of blu-rays, UK television, DVDs, etc. NTSC movies will play perfectly at 24/25fps too, and it's really just older US TV or bonus features where you'd need to switch to 59/60hz.