You want rain and mild weather, the pacific northwest west of the cascade mountains fits the bill. Affordability and within a 90 minute drive to a metropolitan area are not going to happen there.
Closer to the ocean mediates temperature extremes. Also there's more to do. Mountains are nice too, but winters are colder. Maybe consider along the coast south of you all the way to the keys (or the Mexico border, coastal Texas is nice) or the rocky mountains.
Don't discount conservative states, towns and areas if you're not that type of person. A lot of the time the natural landscape is preserved and life is more peaceful. If you're OK with your neighbors going to church Sundays, there's an entire beautiful, low cost country to explore.