@Aaron McCurdy i think you have gotten a healthy dose of smart and super passionate BP people. Its a great thing, but certainly can feel overwhelming. The cool part is as you move forward these same people that are on this thread now will very likely jump in and answer specific questions that you have. That, or the questions will be already addressed on another forum.
In an effort to get back to some information that might help you make the decision that you are faced with now. I would push back on the 24/7/365 aspect of either rental properties or car washes. While technically, that is true I have not seen much of that in my experiences. I have 4 duplexes and have never gotten the 2am call about a clogged toilet. The main reason for that is a decent property with decent renters. That has been a priority for me so that I don't get those calls. With regards the the car washes, very few people go through the car wash at 2am. Nearly all of my business is from sun up to sun down. Its hard for things to break if nothings moving.
Speaking to you family life, we have a similar story with 2 young (not in school yet) kids. I have found a healthy amount of flexibility in my schedule to allow me to spend time with my family. For instance, yesterday we were all walking over to the local park for a picnic and I got a call on my cell phone (google voice number) from someone at the car wash who put quarters in the vacuum, but the vacuum didn't turn on. I apologized, got her address and told her I would send her a check for the $1.00 she put in. Its a bit clunky, but I probably only get a call with a problem every couple weeks. So, 2-3 problems I need to take a call on per month, by 12 months = at most 36 calls per year with an average 30,000 cars washed per year. Seems like an ok percentage to me.
Shifting to the business side of things. When I got involved, I didn't know anything about car washes, but was able to work a deal with the seller (car washes sat on the market for over a year without for sale signs) to have him finance a small portion of the loan. The upside to this, is that he has a bit of incentive to see me be successful. He happens to be a great guy, which I learned while following him along at the car washes a few times while we were working on the deal. I would totally recommend working out some deal with the seller. Car washes have so many moving parts, and walking in blind would be VERY tricky. I have reached out to the seller with questions about the people to talk to for things, especially short cuts he has learned over the years. Another aspect to consider is because you don't just need to find a few tenants, you may want to buy a healthy business vs one that has gained a bad reputation over the past number of years.
In summary, I think a car wash business could meet many of the needs you are looking for, and if cashflow isn't a huge priority, you may be able to find a couple people who could do much of the day to day aspects of the business and it could become pretty passive much like a property management company can make an apartment building passive.