Its silly that stake in your heart, when lay in your lair cause your complete destruction ... but anywhere else, in any other case, you just laugh to that. :-/
In my opinion, not more ridiculous than that the stake has to be wooden in general lore. Obviously I haven't tried it, but I would make the assumption that a metal stake would pierce a heart just as easily if not more...
I'm not that much traversed in Forgotten Realms vampire lore but I guess that the resting place part somehow adheres to you giving them their final rest? Something similar to liches and their phylacteries etc...
It's all about which lore you prefer. In Twilight vamps sparkle(!) in the sun but don't burn. In True Blood they are weak to silver which seems to do nothing against werewolfs etc. I've come to the conclusion that Niara cares more about Forgotten Realm lore than you do Rag and as has been established in the immersion thread, immersion is not high on your priority list but it is on Niara's, who in turn care less about game mechanics being potentially fun and comical if they in turn also break the picture she has of the game's universe. In other words...this will be yet another area where you will have to agree to disagree.