Evaluating Spatio-Temporal Forecasting Trade-offs Between Graph Neural Networks and Foundation Models