Hi danny,
My understanding is that you can only pick up your visa from the consulate/embassy you indicate on your MFA application, so I'm afraid you won't be able to just walk in and get your visa from any consulate without making prior arrangements. Mark007 seems to have gotten his in Dubai within a day, so that's what I'd do in your place. Good luck!
