I tried once. We had a couple of specific areas where we wanted some ideas and help. We took the guy through the house, showed him the problem areas, told him we were on a tight budget, and gave him links to our Pinterest light boards.
He came back after two weeks with £9000 worth of light fittings for one of the areas. It was very nice.
I never contacted him again, and he, quite wisely I thought, didn't pursue us for part of the few hundred quid he'd suggested the whole process would cost.
I don't doubt that working with the right lighting person would be absolutely awesome. The problem is getting someone who can do something interesting without immediately reaching for coloured LED strips in cove lighting (fair play to you if that's what you like - it's clearly very popular - it just isn't my cup of lapsang souchong).
One thing we've done in some of the public areas of our house is use wall lighters. We found some modest, relatively reasonably priced lamps that provide enough light to see by while giving, we think, some atmosphere.
The other thing is to consider using 5 amp circuits and/or home automation to easily allow the use of secondary lighting such as lamps and wall lights. Personally, at night the last thing I want on is downlights, so in our house, they're secondary lighting in most rooms!