The sentences where commas are used correctly are:
- The attorney, offering good advice, is my neighbor.
- My neighbor, a practicing attorney, gave me some good advice.
The other sentences use commas incorrectly. The first sentence has an unnecessary comma after "neighbor," and the fourth sentence incorrectly places a comma after "attorney."