The first suggests that you think that the person you were thinking about is the kind of person that you CAN imagine playing football.
My son really likes playing tennis.
Really? I always thought of him as playing football.
The response isn't very good English. It would be better said "I always thought of him as they type who would play football".