Having experienced 5 close bereavements (both parents, DH, MIL and an Uncle) and a smattering of friends / acquaintances, I think I've heard every variety of well meant but crass platitude one could imagine.
Icing on my particular shitcake was someone on my friends list, who I didn't know personally, messaging as a good JW to tell me my husbands undiagnosed cancer and unexpected death was punishment from God for being a Goth, that I needed exorcising, and that I should hold my loved ones close as they would soon be taken and I'd end up sick, homeless and impoverished. (Yes, I appreciate NAJWALT, nor Christians in general).
I think in general bereavement is the most awkwardness inducing circumstance for so many people, and we've kind of lost touch with the reality of it. I blame things like social media etc, and the way such a messy complex and personal thing can become a bizarre marketing exercise.
As for the "better place" thing, I too resent that implication, because of course our feeling (generally) is that our loved ones best place is with us in the here and now. If you don't "believe" or haven't really thought about it much, the grieving brain can go to some very weird and tortuous places around the subject.
It's all complex, moreso for some than others, and it's a shame because sometimes thoughtless comments, even meant well, can do quite alot of damage.
I don't even think it's about being offended per se, it's just extra painful input on top of already unbearable pain. I don't know what the answer is. We're messy creatures, life and death is messy to navigate, and we all muddle through to a degree.