If you love physical books than I do recommend buying the Grindhouse Edition if you are able to find it. The box set is well worth the cover price but I don't know how much it would be for you now.
The "Weird" in Lamentations seems to have been picked up in other games too. Specifically Gygax's Appendix N from the Dungeon Master's Guide
http://www.digital-eel.com/blog/ADnD_reading_list.htm
I also liked Baker's ideas of "cursed" magic items in "Seclusium of Orphone of the Three Visions" where many magical items are tools for specific needs and the curse comes from ignorance of the object's intended purpose rather than a sadistic wizard with too much time and experience points on her hands.
Which leads me to also recommend Seclusium as inspiration for weird. But do take a moment to seek out the reviews before buying that book merely on my recommendation as there are some who took issues with some of the things that I liked about it.
Raggi's published adventures are also good indicators for adding weird into games. Better Than Any Man (Free RPG Day 2013) and The God That Crawls are two examples of looking at the world's timeline and then adding something alien (wonderful, horrific, awful, amazing, otherworldly) and going from there.
My thoughts on Lamentations and by extension Fantasy is that most Fantasy stories are horror stories but with hope still shining a light.