I have open concept with an island with a sink and after reading many threads here I scratched my plan to have clear glass and went with ribbed glass and a lens which spreads the light downward. You’ll need good lighting at the sink. Your inspiration pic has a large skylight and no sink in the island. I would not do a lantern type. Where is your dining room. Would it be the space from where the perspective originates? If it is, you could use a different color/material since there is some space separation with the wall opening. I would also repeat the chosen color/materials in another way in the decor of the DR.

I like a lot of light as well. I think everything is well lit except for your family room. Definitely not enough light in there (especially if you want the option of a brightly lit space. There is no center lighting and everything has been arrange around the edges of the room. IMO, what you have is a HUGE span with zero lighting which is not at all adequate. Some people prefer room edge lighting and that’s what they’ll recommend. But if you like a lot of light, I don’t think the way your designer set things up will satisfy that need. If it was my home, even though the ceilings are only 8 feet, I would want a center fixture (small chandelier or semi flush)...something pretty. If you are not sure about your furniture placement they can always install the box with lots of extra wire looped in the ceiling so you can adjust it later. Just take pics of your ceiling joists when it’s all opened up (if it is opened up) so you know where everything is located. Makes it easier later. You’ll have a little sheetrock repair, but completely manageable. I would add more cans/wafers around the center of the room and put them on a dimmer. You can always turn them off or dim them if it’s too much light, but if there’s nothing there, you’re stuck with a dark room and no real way to fix it (other than having your electrician return and hack up your ceiling). I’m not a fan of LED, but some people love it. Just make sure you like the type of light they put out before you bite the bullet on them.

Photos? the kitchen/dining colors don't sound like they match your LR furniture. UNLESS, the sofas are all ivory and you can replace the accessory colors. OR, alternatively, paint the kitchen wall a blue or green or soft white (which may be easier in the long run!).

If you want help we need a lot more info. Pictures are great if the space is done and if not than the floor plan , the ceiling height your style all need to be shared. Lighting is best when done in layers of light so a mix of ceiling, floor, table drops . are all needed. IMO DR lighting should light the table not the ceiling , all kitchen lighting should be LED 4000K , I happen to like that daylight lighting everywhere . I do not think kitchens need dimmers but they do benefit from under cabinet lighting on a separate switch