I don't keep an official record, but unofficially I would say that the worst sleep I ever got in my life was the night I did my home sleep study. I was dead set against using a CPAP and was really anxious about "failing" the test. My wife started CPAP about 3 years earlier and I really did not want to go down that road. While I thought I never slept, they told me it was enough for a diagnosis. I recall the machine I used was the Phillips Alice NightOne. It has a built in system that evaluates the test and the data, so they know when you return it if the data is good enough or not. And I did "fail" the test with an AHI of about 34 - Severe Apnea!
And, I will warn you that the second worst sleep of my life was the first night on the CPAP as a trial. It did not go well, and I was prepared at several points to throw the whole machine out the window. But, I did manage to keep it on all night. That was 6 months ago, and I can say that I have used the CPAP every night since averaging about 8 hours a night. I now look forward to sleeping with it, as it does give me a more restful sleep despite the initial pain of it all -- most of which was in my head as I was so against having to use one.
You may want to do a little research on apnea while you are waiting for a diagnosis. It is of two basic types, the more common obstructive apena where your airway blocks air flow, and central apnea where the body just decides not to breathe. CPAP treats obstructive well, but central not so well. The point is that when you get your diagnosis if it is positive, be sure to ask for your breakdown of central vs obstructive events and what impact that would have on a choice of a machine. Also demand a written report of your sleep test results and diagnosis. If you end up buying anything out of your own pocket for equipment, you need a prescription.
You also may want to do a bit of research on machines as you may want have some influence on what you get. There are dumb brick machines that collect no data and usually have only one fixed pressure. I would try to avoid them. The newest machines collect data which can be displayed in a software program called SleepyHead, and automatically adjust your pressure. The two best machines for basic obstructive apnea in my opinion are:
ResMed AirSense 10 AutoSet For Her
Phillips Respironics DreamStation Auto
Both will work, and both collect data and are compatible with SleepyHead, but the ResMed has a few additional features that the DreamStation does not.
Hope that helps some,