There's more choice than just 'megacity and walk everywhere' and 'bumfuck nowhere and drive everywhere'.
Small/medium towns with a fairly dense downtown/market square exist, and while yes, it's more useful to own a car there than in a large city, you still can get tons of things done by walking, biking or taking a bus.
Random example: Alsfeld, Germany, population 16,901. A 1900s house (3br, 120m^2, downtown) 180kEUR [1]. Within walking distance: daycare, multiple doctors/dentists/pharmacies, restaurants, stores... and a train station with an hourly regional train.
Small/medium towns with a fairly dense downtown/market square exist, and while yes, it's more useful to own a car there than in a large city, you still can get tons of things done by walking, biking or taking a bus.
Random example: Alsfeld, Germany, population 16,901. A 1900s house (3br, 120m^2, downtown) 180kEUR [1]. Within walking distance: daycare, multiple doctors/dentists/pharmacies, restaurants, stores... and a train station with an hourly regional train.
[1] - https://www.immobilienscout24.de/expose/130222273