DP was a SAHD for 8 months (DD 10-18 months) and we all found it a very positive experience.
I was happier working knowing that DD was being cared for by someone who loved her, rather than someone who (as good as they might be at their job) didn't.
I watched them bonding over the months which was very touching as long as you learn not to be jealous. Although he's aback at work now, they still have a very good relationship and I think he's more hands-on than other dads. (though, not as much as I'd like)
DP loved it. Had his up and down days of course, like we all do, but did not want to go back to work and misses it still.
Although currently DP works full time and I am SAHM with a bit of freelance, I think we'd both be happier working part-time and this is what we're aiming for in the long run.
Personally, I think all men that can do it should do, and since your DP is at home anyway, it would be mad not to even try it.