Botanical natural products have been widely consumed for their purported usefulness against COVID-19. Here, six botanical species from multiple sources and 173 isolated natural product compounds were screened for blockade of wild-type (WT) SARS-CoV-2 infection in human 293T epithelial cells overexpressing ACE-2 and TMPRSS2 protease (293TAT). Antiviral activity was demonstrated by an extract from Stephania tetrandra. Extract fractionation, liquid chromatography-mass spectrometry (LC-MS), antiviral assays, and computational analyses revealed that the alkaloid fraction and purified alkaloids tetrandrine, fangchinoline, and cepharanthine inhibited WT SARS-CoV-2 infection. The alkaloids and alkaloid fraction also inhibited the delta variant of concern but not WT SARS-CoV-2 in VeroAT cells. Membrane permeability assays demonstrate that the alkaloids are biologically available, although fangchinoline showed lower permeability than tetrandrine. At high concentrations, the extract, alkaloid fractions, and pure alkaloids induced phospholipidosis in 293TAT cells and less so in VeroAT cells. Gene expression profiling during virus infection suggested that alkaloid fraction and tetrandrine displayed similar effects on cellular gene expression and pathways, while fangchinoline showed distinct effects on cells. Our study demonstrates a multifaceted approach to systematically investigate the diverse activities conferred by complex botanical mixtures, their cell-context specificity, and their pleiotropic effects on biological systems.