I'm trying to figure out how to translate the idiomatic expression "Bless his (little) heart" into German. The general sense is: "He meant well, but, wow, was that ever dumb!" I don't think the literal translation segne sein Herz will work here.
I would translate it as:
He meant well (but).
to quote the other response:
It was meant well (but).
I'd never use 'Gott' in that expression. God no. :-)
It will depend; as a parenthesis of sorts "Gott segne ihn" should work. If you want a full sentence, I'd suggest "es war ja gut gemeint, aber ... " oder "er hat es ja gut gemeint".
Do you have a fuller example?