It depends on how it’s used. In DnB and Dubstep it can be quite accepted/acceptable to rewind a track you mixed in and start it again at the beginning of the track. This is often used to please the audience and have the benefit of hearing the full build-up of the track.
However, I truly dislike this practice and would certainly discourage it. I’ve already heard which track you are going to drop, don’t make me wait for it while the intro is playing again. The only time it might be acceptable is when you are playing a track you produced yourself and you want people to hear it completely.
Using it as a transition ‘effect’ is possible but needs good timing. It could work if the end of your spinback coincides exactly with the drop of the next song. I don’t think it would work for most house tracks as you really need a distinct drop for it to work.