If you do decide to have the test done, 23andMe is the lab you want to test with if you want medical information as they are the only lab approved to sell tests for that purpose . . . just remember that you should talk with your doctor about the results rather than simply taking 23andMe's analysis as proven. BTW, for what it is worth, in my opinion the state of the science right now has not progressed far enough to make the tests done by 23andMe worth investing in unless you are a female and are worried about the one type of cancer they have been approved to test for.
If your husband does not want to find or be found any genetic family, you are not going to be able to use his results for genealogy . . . you simply set his account to private and, as I understand it, no one can see his data and he will not be able to see that of others.