When you open this window, it should auto show you your dungeon or raid that you are currently in

Why isn't this something that can be added? Seems like a big time safer for older dungeons.

Due to some AceConfig library limitations (for example the library does not notify when the configuration window is opened) , there is no easy/non-hackish/straight forward way to implement this.

Update to 2.3.17-beta, the "auto open debuffs for current instance" toggle in general options should be checked to enable this feature. The debuffs are updated only when the configuration window is opened or reopened.

Im on latest version:

That option is not available to select:

Sorry, my instructions were not very clear. The option is in general settings tab of raid debuffs options:
Statuses/Raid Debuffs /General Settings Tab/Auto open debuffs option.

perfect, tested it and works great!

I found an issue with it. I went into Azure vault and it was showing wrong dungeon:

Azure Vault is working fine for me, but i did test just in the starting zone of the dungeon.
If the addon cannot detect the dungeon, this should be due to the game is reporting and incorrect map/dungeon for some subzone/submap in the dungeon.
This happens in some dungeons subzones all along several expansions due to incorrect data stored in the game that was never fixed.
If you can go to the wrong zone and repeat the glitch, then you can enable debugging for Grid2RaidDebfufs module in General/"About" Tab and report back what zone is reported by the game in chat.
When you enter in the glitched subzone or if you reload the UI in this zone the chat should display something like this (but probably will display a wrong zone name and/or numbers):

Grid2: DEBUG Grid2_Grid2RaidDebuffs Zone[Azure Vault] C_MapID[2073] EjID[1203] mapID[102515] Status [raid-debuffs]: 21 raid debuffs loaded from [1203]