I've only activated it once or twice, and I got absolutely no diamond dragons while it was activated. Now it's just a decoration in my park as far as I am concerned.
I sell mine when it’s not activated. You can sell it to save space and then buy it when you want to use it again.
I must be in the minority but I’ve always had good luck when mine is activated on my main account.