Coke Zero is a lot closer, but Diet Pepsi and Pepsi Max are both vastly better approximations to their non-diet versions.
RC Light, though, is the only diet cola I've tasted that ever got close to fooling me into thinking I got the non-diet version. It's worth a try. But RC tastes quite different to Coke (much stronger caramel taste) so someone looking for a diet alternative to Coke might not be happy with it.
I miss Diet Pepsi (can't get it in Norway) - Pepsi Max is ok, but it's not the same. Since work ditched Pepsi I've cut way back on the amount of soda I drink. I suppose that may be a good thing, but I still miss the taste.
Diet Coke and Coke Zero are only two of their diet colas. The original was TaB, which is still sold today.
I switched from sugar in my coffee to stevia about 1 1/2 years ago, it was the first non-sugar sweetener I tried I didn't find disgusting.