Different options here.
Wheel-on and direct-drive trainers.
You have, “dumb” trainers, which don’t auto adjust resistance
You have, “smart” trainers, which can give you data estimates (speed, power, cadence)
You have, “smart erg mode” trainers, which can give you data estimates and adjust the resistance automatically.
Wheel-on are generally more affordable.
Road feel is not as well replicated.
Wear on the tire (ideally get a trainer tire)
A lot noisier (although some are pretty quiet if you shop around, like STAC ones)
Easy enough to setup if you keep your road tire (since you keep your wheel on)
Direct-drive are generally more expensive.
Ideally need 2nd cassette if not provided in package
Takes a little extra time to switch from outside/inside mode
Better road feel
Dumb trainers are the cheapest
means you’ll have to whether get a speed/cadence sensor or powermeter
you will have to generate the power with your own legs and will to stick to the wattage (no automated resistance to help you stick to your watts)
Smart trainers are an in between
you still have to generate the power on your own volition but the sensors on the trainer calculate estimated power/speed/cadence. Not always accurate/transferable but it’s a good relative effort/progress measurement.
Smart erg mode trainers offer the most options but are more $
you get to choose between erg mode or non-erg mode
on lazy days you can just turn on erg mode and not have to think about it as much
erg mode “keeps you honest” with the power output
So depending on your budget, and what components you might want for your rides (or might already have) i’d say whether you get a highish end wheel-on smart erg trainer or a lower end direct drive trainer to keep it under the $1k mark.
If your thinking of getting something for the next several years like you did for your computrainer maybe spend the money on a better direct-drive one like the tacx neo suggested above, if you want budget/value and might want to change after 1 or 2 seasons, something cheap like the tacx vortex (gotta find sales) could do…but you do get what you pay for