Big markecap altcoins are somewhat called good altcoins, but still that depends on how every will see a certain coin.
If we are talking about altcoins that won't or avoid to invest, I think there's thousands of then, or maybe 10 thousands or more.
The fact that majority of the altcoins are scams, I believe 90% of the altcoins are not worth to invest in.