We turned a second bedroom into an office and we also have one down in the basement. My husband likes the basement office since it keeps him far away from the kitchen. He has to make an effort to get upstairs to get water or food. Keeps him from just sitting all day long.
I have a front room that I use for both my home office, reception area for clients, and workshop/apothecary for making my products. I just use a couple of curtains to divide the space and it works wonders! It is, however, right by the kitchen. Luckily that hasn’t caused a problem for me!