I guess this is a hot take but I've always loved CV2 and I've been doing a playthough around once a year for about 30 years now.
There are some games that use to be praised back in the 90s, or even the 00s, that get a lot of hate today, this being one of them. I do wonder how much of it is from people (of any age group) purely forming opinions from youtubers/steamers instead of just playing the fucking game. I always wished there was more titles like CV2 on the NES, but at least there was also Zelda 2 and Battle of Olympus.