Thousands of NHS ADHD patients are waiting up to seven years for an initial assessment, with no access to support in the meantime.