Most gigs I end up at either have little or no unit tests. Typically what are described as the unit tests are actually integration tests and will be rarely run from the developers machine. I usually start my evangelism by preaching the difference between the two and try to get people to write very focussed unit tests and leave the integration tests for later, i.e. when enough people are writing unit tests that we can "move on" to writing the integration tests. Acceptance or system level tests are usually handled manually by the developer and then by the QA department.
My question is when working outside of an Agile environment, how much effort do you put into unit, integration and acceptance tests and what do you see the most value from?