Yes, pumped hydro is really a niche option. As you said, it requires specific terrain - good luck when you have a flat country or no water nearby. It also tends to destroy the nature to some extent.