THing is they've clearly put in massively different levels of effort throughout the game in single player at least.
You have area's that have lots of trees/plants and they look significantly better, but other area's that are more in city, have really bog standard decade old textures, I saw a random hotel luggage cart very early in the game and it looks hilariously awful and out of place, boxes the same, tables, sofas, the cars look pretty poor.
Buildings look, meh, there are particular areas like trees/plants they have clearly spent a bit of time on and others like general textures of "filler" items that litter particularly in city levels that mostly look terrible.
Some parts of the game can therefore look relatively good, others look pretty awful. The main thing is maxed out the performance vs visual quality is truly pathetic. Other games look significantly better, play smoother and perform significantly better.