Some apps (like photoshop) won't run without a pagefile. If windows doesn't need to use the pagefile it won't - it won't constantly be accessing the pagefile during games (unless you have low RAM), it will chuck anything it wants to in the pagefile when you start loading. I'd say leave it on, you won't notice any performance difference and I believe Windows will still use a pagefile even if you do disable it (not totally sure of that). That way you'll avoid any potential problems.
If you want to see whether it would be worth it the only way is to try and then do some benchmarks, but I doubt you'll be impressed.