Actually it's not only cosmetic. He is Financial, which should give +1 commerce in 2+ commerce tiles. And even this not showing, it's counted inside the city, you can check on your venice start, it should be totalizing 11 coins but it'll be totalizing 12, and try to use 2 water tiles instead of one, you'll see miraculously 2 extra coins out of nowhere