[Delboy]

The reason the battery goes completely flat is the bem is only capable of shutting down non critical loads, if you study the electrical diagrams you'll see that most devices are wired in a way where they connect directly to the fuse box and if that device doesn't go to sleep or is not controlled by the bem then it's going to continue drawing current.

The lights on the console are a sign that the cars not going to sleep and is constantly sucking the life out of the battery.

I have had door handles do it too me, i've seen on the internet things like bad instrument cluster, tv tuner, water in mmi panel, faulty alarm and probably more that can cause this so its just a matter of figuring out whats pulling it down.

Have a look at the attachments, give you a place to start.