Hi...
I am not sure there is such a thing as an "ideal" work space.
I built a 12'x12' hobby room in the garage few years ago. One wall has an 8' workbench with cabinets under it and a 4' wide, 7' tall cabinet next to it for storage. Another wall has a 4' long reloading bench against it and the room entry door. In the opposite corner is an L-shaped desk set-up for research and a computer workstation.
Positives: More than adequate lighting...room is separate from the rest of the house...room is heated and air-conditioned.
Negatives: There is no room for my library or to display finished models. All the storage area is full and I have plastic storage boxes full of stuff under the L-shaped desk. My modelling tools are in two toolboxes...the ones used most often are in an oak machinists toolbox on a raised wooden rolling cart. The balance of my modelling tools are in a plastic tool box sitting on the floor. All painting must be done in the garage.
I am seriously considering ripping the whole thing out and starting over. I should have made the room at least 16'x12' and built-in bookcases and display shelves. In retrospect, I should have designed a separate area for painting with outside venting.