Lost Con points from Raise Dead actually can be recovered, but only through the Fix/Repair option in temples that offer it (which basically means that you have to live with the lost point until you reach the final game in whichever series you're playing) - this resets ALL asterisked stats to base, unless there is an ongoing effect responsible for the stat change. Since Raise Dead for some reason treats the Con change as a temporary debuff (asterisked) instead of a permanent change to the basic stat, and doesn't place a corresponding "was raised" spell effect on the target, this works
Quite useful in Treasures, if you're in the islands and take a boat back to Neverwinter to get a rez while having a Cleric of level 9-10 in the party, seeing that the game "helpfully" automatically performs a camp Fix for you on every boat ride, resulting in the character getting Raised when you wanted to wait! Of course every island location (except the final area past the point of no return) has a Temple, but you might not have remembered that fact in the rush (or if you're in Fireshear and innocently decide it's more convenient to take a boat back - particularly as the area you're most likely to actually die in is right by the boats, while the Temple, if you remembered there was one, is a long hike back through the whole zone ...).
Snake Charm was also useful in Champions (perhaps even more so, since you had Lightning Bolt as a mass damage option in Naulidis to help with the sea snakes, while the low level characters of Champions frequently had trouble quickly eliminating the hazardous Giant Snakes - didn't help that you encountered them mostly fairly early on!).
However, I'll agree it's pretty much mainly a Krynn series thing. Could be useful in Pool of Radiance I suppose but the mass groups of humanoids and level 6 limit brings up the spell slot supply issue and competition with Hold Person (this is much muted in the Krynn games; while on the one hand you actually have triple competition for level 2 Cleric slots thanks to Resist Fire being so often important as well, you're usually pretty much awash in Cleric spell slots because of the useful multiclassing and Knights' robust Cleric spell allotments at high level meaning you usually have most, if not all, your party members having Cleric access; plus Hold Person is far less frequently of use because you get so many Draconian opponents where the FR games would have had more humans); later in the FR series, snakes have become so weak compared to your party that you tend to just obliterate them without worrying about crowd control (as they don't get a meaningful upgrade like DQK's Sea Snakes), and in the only other low level FR offering (Gateway) they've been nerfed significantly (Gateway snakes only paralyzed you, not killed, at least in the PC version).