Same issue in my Happy Place... one light fixture/ceiling fan combo in the middle of the room.
We planned to replace the ceiling fan/light fixture anyway, but held out till we found one made by Hunter that was made for LED bulbs that dimmable. Then picked up the daylight LED bulb and oh my - let there be light!!!
I don’t use the dimmer at full brightness very often but its there when i need it. You do need to have a dimmer switch already installed (which i had) and you also need to get the LED daylight bulbs that specify “dimmable” as not all are.
I do also have a floor stand Ott light at my cutting table because its in a darker corner of the room and have an smaller Ott light on my sewing table just in case.
All of my machines are set up in an “island” configuration at the center of the room and i always have the light i need and more!