How tall are you, and how much room do you have? I'm 5'7", and I can be comfortable in a 10 foot hammock in one of those 9 foot long stands, but I'm a bit *more* comfortable in my 11 foot hammock, which doesn't work with those stands.
Do you have trees in your backyard so you can experiment with whether you enjoy the hammock before you spend a lot of money on a stand? Or maybe you could go on a camping trip? All the hammocks I'm recommending come with tree straps, so you could order the hammock first and give it a try outdoors before you spend any more money. Worst case scenario, even if you don't like sleeping in it overnight, you'd end up with a hammock for lounging around in 😀
If you're on the short side, and on a budget, a 9 foot long stand like this one ($75) will work. I've got one that I use when I travel. You'll probably want a shorter hammock with it, like this WINNER OUTFITTERS Double Camping Hammock ($29).
If you're taller and have room for a larger stand, I can recommend the Gold Armor Camping Hammock (currently $32) for indoor use (I used one for a year before my dog tore a big hole in it with his claws!) If you might want to go camping too, you could purchase the Ridge Outdoor Camping Hammock (currently $65) which has a mosquito net. It's very comfortable and is what I'm sleeping in now (though I zipped the net off for indoor use 😆)
If you have the room and the budget, a "turtledog" style stand with tripods (or... quadpods?) on each end gives a comfortable hang for a longer hammock with no need for external attachment points. They pack a lot smaller than the 9 foot steel stands, and you can also kind of "half pack" them by collapsing the tripods and leaning it against the wall when you're not using it. There are 2 commercial versions: the Eno Nomad ($250) and the Tato Gear stand ($350). If you're up for some DIY, Tato makes a DIY kit ($150) that has all the hinges and you just supply the poles. Or you can go whole hog and make your own (you'll have to make a free account to see the photos).
If you do end up sleeping full time in a hammock, unless you live somewhere very warm, or you tend to sleep very warm, you're going to want an underquilt. For indoor use and car camping in mild weather, the OneTigris Twilight Trekker ($65) would probably be fine. If you might want to go backpacking, you'll want a down underquilt, as they pack smaller and weigh a lot less for the same warmth. I love my HammockGear Economy Incubator ($140) -- I pair it with one of their Burrow top quilts and it's like sleeping in a snuggly warm cloud 😆
One of the nice things about sleeping in a hammock is that once you've got your hanging situation figured out (I use L Track screwed into my wall studs, but it sounds like that's not a possibility for you), the hammock is the cheap bit. You can experiment with different materials and add a structural ridgeline to your hammock to adjust things a bit, and if you spill a beverage all over yourself you can just throw the whole thing in the washing machine (try doing *that* with a mattress!!!).