I work in the Boston area. I said yes to my first job's non-compete. In each job after that (I'm on my third) I have said no. I've negotiated it as part of my employment.
First job was a big company; second two have been with smaller firms. If an employer wants you I think refusing to sign one is unlikely to get in the way.
I've also, without a lawyers help, modified my employment agreement for my current and last job. I've hired a number of folks over the years and not had them negotiate these types of things.
Always negotiate; you can get a lot of what you need/want.