I play on the new, all-singing all-dancing, latest technology surface at The Falkirk Stadium every week, and it's awful...up there with the worst surfaces i've ever played on...and im a big fan of artificial turf normally.
The only way I can describe it if you've never played on it is that it feels and sounds like you're playing on a 3 inch blanket of snow. If it's raining it's slidy enough to have to adjust your movement so you don't end up on your backside every time you stop or turn (even with mouldies on), and if it's dry the ball holds up something ridiculous if you play it along the deck.
You do get more used to it after a while if you play on it a lot, but it's horrible.