Cc6 is one of the best comfort tyres I have used. I'm running on cc6 195/55/15 on my myvi for almost 2 years now. It is quiet but does get noisy when you drive above 110 but it's still tolerable.

Grip wise, its more than sufficient for normal use. Dry grip is pretty good for comfort tyres. Wet grip, as long as you don't push the car, it's okay. Always remember to pump with the correct tyre pressure. I once pumped 35 or 36 psi can't really recall and I skidded on jalan Travers. Well the road was damp and I was pushing the car so that contributed to the skid as well.

Overall, 9/10 for cc6, in my opinion.

Yup. Grip can't compare with other tyres but it's sufficient for my driving style. How much does the es32 cost nowadays?

Well, this es32 got a lot of positive reviews. It looks like a very good upgrade over the old blue earth model. Price seems reasonable too. Like what @chezza said, it's a well rounded tyre for normal daily driving.

You can contact yokohama and ask them to locate the nearest dealer to you. Other option is buy online and get it fix at your tyre shop.

You may want to try hankook ventus v12 evo2. Should last the same length as your PS3 as they have similar threadwear rating. Similar performance with ps3 but much cheaper. I'm using it on my myvi too. Can get it for rm165 for 195/55/15. Your size should be same price or cheaper

Based on your list
Tr1 - better performance than re003, should last longer than the re003 but shorter than ps3 Price around rm170-rm190

Neo - this aren't high performance tyre. It has higher threadwear but you have to sacrifice grip for this.

Yoko Blue earth - not a high performance tyre, but it gives better grip than the neo. It's a good all round tyre. But in terms of grip, can't match ps3.

Advan fleva - high performance tyre, good in dry and wet but got mixed reviews so far.

If you really want good grip in dry and wet, you can consider the hankook ventus v12 evo2. The performance you get from the price is really worth it.

If not, from the list above, I'd suggest advan fleva, tr1 and blue earth, in that order.