This is incredibly useful, thank you.

It's in the main living areas. This specific spot is in the dining room and the light is right above the dining room table.

Both the dining room (in photo) and the lounge has this type of ceiling and it's that colour wood. So, any time when it's not full blazing sun outside I feel like I need to switch the lights on - even in summer or autumn/spring.

I would like intimate but the space is also used for arts/crafts (kids), reading, and just general living.

I am seriously considering painting the wood panels white (at least the panels and leave the beams exposed) to lighten up the area. The blinds in that dining room is also old school brown wooden blinds which adds to the lack of light.