Anyone bought or leased a commercial unit and built a small living space for themselves in it? (Zoning in my area allows an accessory dwelling unit.)

I'm just not sure if I can make the amount of space I can get (say 1000-1400sqft at $1/sqft/month) pay for itself. I'm just a one-man shop.