I think I can find a drug for AIDS here.(example)

and it will gives me several similar compounds and CAS#

then I can use those CAS# to search activity data here

for Cancer, use these Drugs list1 Drug List 2 and Acitivity

PS: if interested in anti-cancer plants, you can find it and compounts it produced here or here.