Like most people here I've tried many, many different ways of holding the fabric. For small projects (and quite a lot of my projects are small) I like flexi-xoops, which keep the tension better than wooden hoops to my mind. This may be at least partly because I don't bother to bind wooden hoops, but as the flexi-hoops do the job why should I bother

? They do leave a hard-to-iron-out ring on the fabric if you leave the fabric in for any length of time, so I only use them if the whole project will comfortably fit inside the hoop.
I've used Elbesee Easy Clip-On scroll frames, and they are OK, nice and light and keep tension reasonably well, though it slackens off quite quickly when you get towards the unattached side edges.
And then....
...then I got the Millennium Frame
It is expensive, yes. It takes months to deliver, true. But it is GOOD. It keeps beautiful tension along the whole width of the fabric, and it will keep it for yonks without the need for adjusting. I love it!!!!! They do a lap frame and a floor stand for it as well, but I haven't tried those.