For the majority of cycling, pants with no water-resistant treatment are actually your best choice. Standard cycling shorts and tights prioritize breathability and moisture-wicking, which matters far more than rain protection on a typical ride. Without a water-resistant coating, the fabric breathes better and dries faster, so sweat evaporates efficiently instead of getting trapped against your skin.
This is especially true for road cycling, indoor training, and fair-weather riding where you won't encounter much rain. Most cyclists generate more moisture from sweat than from external precipitation anyway, and a water-resistant layer can actually leave you feeling clammy during hard efforts.
The key is simply to own a separate pair of dedicated rain pants for wet days rather than trying to make one pair do everything. If you ride mostly in dry conditions, skip the water-resistant treatment and enjoy the superior comfort of unrestricted airflow.