what will happen if I walk into a hospital right now telling them I'm suicidal

****TRIGGER WARNING IM SORRY*****

I need a better answer than "they will put you in a psych ward", and already have numbers for the crisis text and call lines in my state. Please do not report me. I am simply looking for more options.

23f with various diagnosed illnesses and disorders. Psychiatrist has known about suicidal ideation for months now, recommended I go to the hospital last week in an emergency video visit. I'm too physically hesitant to actually do legitimate harm to myself or I would have been done it. I've researched how to pass a psych evaluation for purchasing a weapon at my job but I don't think anybody I work with would sell me one knowing my mental history. I can't keep going the way I'm going physically and mentally. And nothing else is working and I don't know what to do. I feel like all hope is gone for me at this point I cannot physically do anything to myself, I've had too many failed attempts in the past. Its safe to say if i havent done anything by now im not going to ( i think), but i still think about not wanting to be alive on a daily, almost hourly basis. I'm petrified of trying to ask for help and someone calling the cops and I wind up getting baker acted or some shit when I'm just trying to weigh all my options