The Broad Institute hosts a very interesting transcriptomic dataset called CMap [1] that was intended to facilitate rapid drug repurposing. Having studied this dataset and worked with the data generators and software teams, I can say that drug repurposing is NOT as straightforward as people think. However, I agree that as a strategy drug repurposing is a useful tool in the arsenal generally.
[1] https://clue.io