If you import files from outside Studio One you do not have to stretch them manually at all. They do not need any special tempo info embedded in them either. All you have to do is simply figure out what the tempo is of any external imported files (which you may know anyway) and simply let Studio One know that info. The moment you do that the files stretch to the session tempo and to any other tempo changes as required. When you import a file that does not have any tempo info in it when you look at that track and its inspector you will see the words 'Not Set' in the tempo window. That is where you add the tempo info and once you do that it will respond immediately. So if you are working at say 130 BPM and you drag in a file that is at 112 BPM
(and the window says Not Set) all you have to do is type 112 in the Tempo Window. The file will instantly change now to 130 BPM. Because Studio One now knows the imported file tempo and knows where it has to stretch it to. Slightly magical.
Acid files are read correctly so no work is required to get them to work either. I have found many loops and things from remote sources already have the tempo in the tempo window and they just work. Every now and then you have to manually put that value in. It stays with the file forever too so if you include it in a Sound Set or just in the browser you never have to fiddle it again.
You have to allow them to stretch of course. You can always tell any files not to stretch as well. But it is usual to allow it.
The whole session tempo can simply be changed by changing the tempo setting on the transport bar. It is as magical as that. It is very nice to be able to play the whole session slightly faster or slower without any fuss. The stretch algorithm is a lot better than most including Pro Tools. Files can be stretched a long way before they fall apart. I still prefer to get that right though at the start. It is cool for complex film cue and they suddenly want it 2 seconds or so longer or shorter then the tempo change thing can be very handy.
The key of the whole session can be changed (transpose) just as fast too on all the audio as well as midi tracks.
Drummers have a very fine sense of tempo. It is our job after all! I can feel a change of 1 or 2 BPM even if the tempo is around 120 and higher or so. I found after years of playing though that it is nice to breath in time with the groove you are playing. Like 4 beats to breath in and 4 to breath out etc.
BTW when Steve Gadd lays down a groove to a click it still sounds killer.

But yes I do also think as soon as you turn it off too magic happens. But only when the musicians are really really really good. Like the guys in Chick Corea's Elektric band for example or an incredible African percussion ensemble. But when the players are ordinary though things often fall apart as soon as the click goes away and then it can be a saviour!
There is nothing wrong with practicing to it, but once you go out live and it is not there then the music can be better. What the click practice does though is teach you to be more constant and NOT SPEED UP OR SLOW DOWN which many ordinary drummers do all the time. Click practice strengthens your internal clock. You can still have that elasctic tempo approach going on and create excitement but the trick is it to end roughly at the same tempo as you started!