Text-space Graph Foundation Models: Comprehensive Benchmarks and New Insights