If you want a more bike like experience, and not a spinning bike experience, what you want is a "direct drive trainer". You take off your back wheel and mount your normal bike and chain on that.
A trainer like that can be used with all kinds of software. Personally I like the social aspects of Zwift. Group rides, competitions, just biking along the map with other people around. For structured workouts Trainerroad is great, but it's also possible to do in Zwift. Other apps like Rouvy exist, probably apps for more traditional spinning sessions as well, or you can just make your own workout in any of the apps matching a YouTube video and put the video on.
A trainer like that can be used with all kinds of software. Personally I like the social aspects of Zwift. Group rides, competitions, just biking along the map with other people around. For structured workouts Trainerroad is great, but it's also possible to do in Zwift. Other apps like Rouvy exist, probably apps for more traditional spinning sessions as well, or you can just make your own workout in any of the apps matching a YouTube video and put the video on.