I have no idea where people get these unreal expectations from. The game is overall good. With one big 'but'. The engine is very outdated. If it looks this bad on release, just think about how it will look compared to other games 1 year from now.
It is just awful for a game released in 2023. The character model quality is the same as Fallout 4.