I'll probably get a lot of hate for saying this, but I guess my main concern would be the stigma and how people would react to it in the workplace.

I think a service dog or ESA or whatever would draw a lot of unnecessary attention at work and would raise some eyebrows. It's not about legality. It's the fact you can get fired for it, maybe because they hate dogs or because they think you're a psychopath who can't handle theirself "and therefore cannot in any way handle work".

All your employer has to do is make up some BS reason to fire you, and then you have to *prove* that your employer violated ADA, which won't be easy.