100 miles round trip? I love my turbo CX-5 but it wouldn’t be practical for that compared to other vehicles. A Mazda3 AWD would be nice but it would be pure commuter to me. Backseat is too tight imo to regularly have my kids in the back. The 6 is a ton of fun to drive with the turbo, I’d consider that too if you need more room for passengers.
I’d personally explore the latest generation Prius. I test drove one after my ‘13 CX-5 was totaled. My 23’ CX-5 Turbo had the height, fun factor, and the utility of an SUV so it won out when I was shopping. Wasn’t driving much before we had to return to the office but my round trip is about 45 miles. 100 mile round trip though, I’d have gone with the Prius. Awesome gas mileage (about 50 mpg for AWD option) with 0-60 time of 7 seconds. Same problem for rear passengers as a Mazda3 though, ceiling is even lower if I remember right.