I would not do great in loft homes since my vague fear of heights would make me wonder if I would fall and trip at night or from the ladder when I am by myself.
For the past 20 years, I've lived in 1 level condos under 770 sq. ft. in different cities.

Perhaps having an extra 100 sq. ft. would give me more comfortable workspace for doing art.

But I did paint, using the dining rm. table for several years. It just means unpacking and repacking art supplies with a drop sheet after a few hrs. of dabbling.

At this time in my life, it is nearly inconceivable t(to me) to have ie. a 1,000 sq. ft. place when we don't have any children at this time with us.