It might be fun. It would only follow the cultural borders of the city in which it is built, keeping barbarians away from that area. That effect would disappear with the discovery of Gunpowder, together with the ability to generate Great Generals at twice the normal pace. And there would be no generation of espionage points at all. Instead, Hadrians' Wall would generate culture for the city throughout the game.