Yes, Coke does seem to have gone way out of their way to make Diet Coke and Coke Zero taste very distinct.
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.
Fun fact: Coke tried adapting the Diet Coke recipe to use real Coke. The result? 1985's ill-fated New Coke.
Diet Coke and Coke Zero are only two of their diet colas. The original was TaB, which is still sold today.
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.