This is how a high poly model made right now for a game model looks.
I say it looks pretty damn convincing. And you should imagine that texturing already is quite good, even in games. The future will bring only improvements since a lot of texture resolution limitation will disapear.