I loved that ending.
I've got to admit that, on my initial reading of the story (back when I was about 12 or 13) I found it quite jarring... enough to
almost spoil the story for me. However, the rest of the tale more than made up for what struck me as almost comic, rather than cosmic. Later readings (much later) had me finding it to be much less jarring, and I began to appreciate what he was doing. I always enjoyed everything else about it, though, and I am one of those who found the historical background utterly fascinating, and the bittersweet ending quite touching. Even with that less-than-pleasing effect, in all other ways the story began as and has remained among my favorites.
Just as a sidelight concerning "The Shunned House"... were you aware of the various levels of genuine history and folklore HPL included there? The Roulet family, for instance, is very genuine, and the story of that ancestor crops up in, for instance, Sabine Baring-Gould's
Book of the Werewolf; the flood mentioned, where the ship actually all but tapped the windows of the house, was a genuine historical event in Providence; the vampire beliefs of the region were also genuine (see, for instance, J. Earl Clauson's "Vampirism in Rhode Island", in his
These Plantations, as well as Faye Ringel Hazel's "Some Strange New England Mortuary Practices: Lovecraft Was Right" (
Lovecraft Studies 29, Fall 1993), and the bit about the "human-shaped figure" comes from
Myths and Legends of Our Own Land, by Charles M. Skinner (in vol. 1, if memory serves).