I had a sleep study done a few months ago, and it showed that I have mild sleep apnea.
The room was set up like a hotel room and it even had a Select Comfort mattress so I could adjust it to a level I liked (no sleep number like I have at home, but I just played around a bit until I found my spot).
I did have the what-seemed-like dozens of wires hooked up to me, but I didn't have a tube in my throat. There's no way I could have slept with that. Most of the wires I was able to ignore, but there were definitely a couple that I was aware that they were there.
I didn't feel like I slept at all, but when I asked for water at about 3:30, the tech told me I had been sleeping fine until about the last half hour. After that, I slept just fine - unfortuately, the place I was at wakes people up at 6AM (other places will let you sleep until you wake up).
I was told that if there was anything of concern that the tech saw on the reports, she would wake me up to try a CPAP machine on me. Fortunately, there was nothing that was enough of a problem to warrant that.
When I met with the doctor about a month later, she told me about the apnea and what it all meant. I was pretty surprised at the charts she showed me too - I had no idea I woke up that often. I was at the high end of the mild range, waking up about 15 times per hour (I think it was measured per hour? or was it longer?). It made a lot of sense though, as I think about how tired I often am.
Her recommendation for me was to have the surgery because at my age (late 20s), I would recover quickly plus avoid the need to have a CPAP machine for the next 60 years. She said that I might need to try the machine for a while to appease the insurance company though.
Her description of the surgery made it seem a lot less risky than what you described, arminnie, which concerns me. She said that I would probably be at the hospital overnight (maybe two nights?) and then be at home for about a week. She said that I would probably have a sore throat for about 2 weeks or so after that, but that I would be OK to be back at work.
I might have to research that surgery a bit more seriously before jumping in. I just wanted to do anything in the world to avoid being stuck with a machine, but I'll definitely have to give the whole thing some thought.