To add, I checked my inventory to see if I had it, which I didn't.

That demon door does not guarantee Avo's Lamentation, it offers a random weapon like any other weapon location in the game. That demon door offers a rare class weapon. For information exactly look here: Weapons_(Fable_III)#Legendary_Weapon_Locations

Thanks! I wasn't aware of that. I just concluded that I would receive one of the two because the page on the wiki stated that I would receive a random legendary weapon based on my moral alignment.

There are numerous moral alignment weapons though, keep in mind that Skorm's Rifle and Avo's Lamentation are merely weapons relating to the old "gods" from the first game.

The general consensus is that you will get one of the three 'good' RARE weapons when you open this door while your morality is good. They are Avo's Lamentation, The Equaliser, or The Shrieking Pilgrim. These are also the weapons usually found behind the Gold Door in the Ossuary.

Hang on it said there will be lava on the lake instead of water if your evil, I got there 100% evil and theres only water anything im doing wrong? anything i need to do like were a certain outfit or something?

Actually, I counted it statistically: the Good Hero receives firstly, the Equaliser; then, the Shrieking Pilgrim; Avo's Lamentation; Scythe's Warhammer; the Thunderblade; Beadle's Cutlass; Simmons's Shotgun; the TYPO; Tannar's Glory; and Briar's Blaster, in descending order of probability (the last mentioned few, very, very, very rare but do appear) - anyhow - there is DEFINITELY not any absolutistic restriction to three weapons; Equaliser, Shriek. P and Avo's L., they are only more probabilistic in manifesting...

Also: no one in all these articles reports what I have seen in entering the Moral View landscape. When most fanatical in altruistic idealism, the statue would be of MY HERO themself and a kind of Latinate-ish rune of obscure meaning inscribed on the statue existed moreover; as far as my eyes can see the screen pixels, something like "REX BELLATOR [PACIFIC/US]" - which, upon "googling", might be Arthurianesque? - and not only buttlerflies, rabbits and birds fearlessly played around me as I walked to the chest, but other quasi-mythological creatures I have no words for... It seemed as if they wanted me to pet them and made a point of showing no fear and complete comfort in my presence. Some thing related: When militantly "good", in the next-to-last Road to Rule visit, similar features existed: the final area was like a heavenly alter-verse, a sort of angel's garden really, with fountain water draining from certain architectural parts supernaturally, peacefully, and other subtle "Dunsany-esque"-type things I'm sure no one will believe, as if letting the player know, "You have succeeded admirably, as a Good Hero and the future shall be cloudless in the end; you have already conquered"...

Playing evilly as my stomach allowed multiply, the Ossuary Golden Door is CHARACTERISTICALLY and INELUCTABLY the provider of not merely rare-class weaponry, but, regardless of personal on-going play-through ethical choices, a profoundly GOOD ALIGNMENT rare-class weapon. Most frequently, the Equaliser, Avo's Lament. and the Shrieking Pilgrim, not excluding others of kindred identity - Beadle's Cutlass and Scythe's Warhammer manifest relatively frequently, e.g. -

So receiving an "evil" rare-class or elite-class weapon in the Ossuary, if truly materially transpired and reported, is an extreme statistical anomaly minimally, and, more realistically, a glitch carrying no import. I have encountered one such example personally.

Every video game, as every humanly concusciple aesthetic creation (DUH), can be "glitchy" and "imperfectly executed", to whatever extent, however phrased, as we human anthropoids are not perfectionist mechanistic automatons of inerrancy - including the creative nuclei class of "devs"...

Also: there are indeed intra-differentiated "good" scenery variations, objectively. I am not lying above, even if the observable details are very subtle and almost imperceptible, and I admittedly probably require a higher-definition television screen to really document this fact... The above scenery picture is a rough, poor sketch I am sure incorrect in some micro-details, but the reality of a hierarchicalized scaled alignment-reading, within each category, is real...