Plenty of people in CV really enjoy living there, and can easily afford it, but if it seems like garbage to you, I’d definitely look elsewhere.
No one should buy a home they don’t love. I can’t imagine doing that. That would be just plain stupide.
We lived in CV before moving to RSF, and still have rentals there. In fact, all three of our kids started school there, until we decided to go private, and it was a great experience.