Hundreds of families say they have had to wait months or even years for a dementia diagnosis for a loved one.