My most positive experiences have been office-based but with flexibility to work from home when needed. I found it was needed pretty often: most offices are no

My most positive experiences have been office-based but with flexibility to work from home when needed. I found it was needed pretty often: most offices are not well set up for productive software development work, and I was much more often productive from home. I've also worked for a remote team at a large company (twice!) -- meaning a small group geographically separate from HQ or the main team on the project -- and found it was a nice excuse to travel, but ultimately I suspect the team would've been better all in one place. (That company eventually agreed and dramatically reduced team geographical splits.)