I have a decent home office setup: dedicated room, nice chair, big monitor, but I still don't get as much done as going to a different physical place that's dedicated to work.
I think what I hated was not the office, but the open office, which is truly awful. I started a new job and now I have an office to go. I'm currently sharing with a couple people (who are rarely there) and soon will have a dedicated private office. It's a world of difference.
I think most people who hate the office really hate: open offices, long commutes, being required to be there for specific times. If you could get rid of those most people probably wouldn't mind and might even prefer the office.