I’m currently using the option “Sound in Background” to make sure I can hear when queue pops, but I’m wondering if there’s an addon or weakaura that can bring the game to the foreground when queue pops
Unlikely as that’s a function of your operating system. It does flash in the task bar on Windows when that happens though.
Bummer! 
Yeah missed the flash quite a few times before, and then resort to using Sound in Background, but I have to move it to a quieter place everytime when I want to alt tab to do something else
Maybe a Sound addon that mutes everything except the the queue pop.
Depending on your monitor size obviously but i just browse the net with my browser covering 1/2 - 3/4 the screen, so when something i care about happens (not often) i can usually tell.