Heyo!

Just out of curiosity, your example is not very representative of most 3d art I know.
If you are talking about really absolutely photo-realistic art, that has been answered already.
But just one thread further below yours (bump order) was this pic for example:
https://boards.guro.cx/3dcg/src/1696529060206.jpg
That is not realistic enough for you? Sure, it's no photo, but not very "cartoony" either.
Pretty awesome at that, using the opportunity to tip my hat to Trrest. Noice.
How about this one?:
>>https://boards.guro.cx/3dcg/src/1750673073626.png

Personally, I actually do prefer a bit more cartoony look, as you can see in my little corner around here.
But that's just me. There is however, examples for 3d artwork out there that is so very much looking like the real thing,
that it is very hard to distinguish.
Came across some pics of that quality just yesterday, but
a) do not have them handy right now, or else I might post those and
b) no gore, so no reason to dig them out either.