Hampden and Celtic Park are both truly awful, for the valid reasons you've outlined.

McDiarmid is a soulless, windswept morgue.  The fact that there are so few fans attend makes it look even worse.