The way it's invisible until you do the right thing and then suddenly it lits up, but then you still have to figure out how to get in. The rest... the fire thing feels like a bit of a stretch to me, but the falling, yes, agreed. In both books it's the mentor figure showing just how important he is once more - and then falling to leave the mission in the hands of someone unprepared for it, but not incapable of it. And Dumbledore will return, in a fashion...

Good magic not being flashy is of course also a Tolkien thing. But Dumbledore can be plenty flashy when he wants to be, as we've seen before.