Neurontin gave me hypersomnia. It makes you extremely drowsy just like Trazadone. It is still worth a try. It might be different for your husband. At the time, I didn't have insomnia but was instead taking it as a mood stabilizer.
I don't know about the Neurontin. But I have, over 15 years of dealing with chronic insomnia, recently found something that, so far, is working wonderfully for me. It's available at all major drug stores, health-food stores, etc. It's Hyland's "Calms."