I find that having Elder Gods is only cool when portrayed with a sense of mystery. That is, their motives are unknown and completely deviating from any concept a human might be able to comprehend. It's a little difficult to write, but once you get it right, it's pretty fun to read/play. At least that's how I do it on my CoC campaigns- not that I've actually run one in over half a year.