>I'm probably not going to hook VFP to TFS, but VS2008 (which I want to connect) should be able to work with TFS2010 if the MSSCCI provider as well, I assume?

If you're just going to use VS2008, then I don't think you need to download the provider. In my copy of 2008, I just use the Visual Studio Team Foundation Server plug-in for source control and I'm able to connect to our TFS just fine.