I'll second the Brazilian hammock suggestion. I'm a warm sleeper and the all-cotton nature seems to be the most comfortable to me.

I've slept in a Mayan as well, which is also very comfortable. I don't care for the materials used in camping hammocks, though, so those are off my list.

I use a small pillow behind my head and a tiny pillow under my knees. I also was a stomach sleeper, but find I can sleep quite comfortably on my back diagonally on a hammock. The head being slightly higher helps.

I don't bolt mine into the walls. I have a compact hammock stand. It's similar to this one. I find a good cotton Brazilian hammock will last about a year or year and a half and then I replace it when it gets too stretched out or some of the strings start fraying. You can buy a good one for $50-125 though, which I think is reasonable for a year's worth of good sleep.