Yeah, it will be quite different depending on where you end up. But a lot of things are pretty universal. There are a few "types" of psych wards, and I would say to do a little research about where you would specifically be sent. A lot of the smaller places are just units of a larger, multipurpose hospital. And I would say those are the best ones imo because they tend to have nicer, less jaded staff and shorter stays associated with them. Depending on where you live, some places can override medication refusal, but they only really tend to allow this for schizophrenic or life-saving meds (the laws do depend on where you live, but the medications they're allowed to override should be clearly listed somewhere). I have refused SSRIs, SNRIs, mood stabilisers and the like with no issues.
If you don't have a lot of social support right now, it won't change anything to go into the psych ward anyways, right? I'd say it's worth a shot. And the nurses and techs at smaller places often get to know you, so you'll have that support at least until you discharge. Plus, people who are deeply disconnected with reality don't stay at smaller psych wards very long, as they end up sent to longer-stay facilities, so you'll probably be able to relate more with the patients who are in there with you.
Usually if you want to be able to leave and come back, that's only a thing for long-term facilities or specific recovery programs like IOP or PHP, though, so unless you plan on being there for the long haul, I wouldn't plan on that.
If you don't let on that you're still suicidal (or, actively suicidal, you get out by saying you've stabilised and don't have plans to do anything), you should be able to stay in a smaller hospital for around a week before discharging instead of being sent somewhere larger. I usually have good experiences with smaller places, and it can be somewhat of a relief to have that excuse to be "safe" for a little while.