No it wont be anything like simgle player.... in SP the speed of the net connection doesnt play a factor.
Anyways try it and see.... I played for months on 56k and loved it. if you can connect theres no reason not to play just because you dont have a good connection.
Youll also be dong well to get a sub-100 ping on 56k.