I have tried (and broke) various trainers over the years.
Best ones are rim drive rather than on the tire, they are smoother and quieter. And they don’t have that horrible lag as the pedal catches each revolution hard to describe but can’t be good for your knees. And easier to set up properly. In fact just stay away from the ones that sit on the tire.
I have a Minoura RDA80, can’t remember how much it was but seems to work fine.
You will also need a phone book for under the front wheel, a selection of old gym towels, a well aired room and music within reach. And old bit of rug to go under it if you have carpet. I use track mits too, you really do sweat that much.
Good luck, it’s not everyones cup of tea and IMHO more suited to short sharp high end stuff but better than doing nothing. Some people find it too boring.