Or in lieu of that, recommendations on what types of cars to get (i.e., new, used, certified, lease)? Any advice would be helpful.
I don't know a heck of a lot about cars. I buy them and then I drive them until they become unreliable and then I get something else. While some people get invested in their cars, I consider them appliances.
I have had an Audi, a BMW 325i, a few Volkswagens, a Nissan Altima, an Oldsmobile Intrigue, a Dodge of some sort when I graduated college, a few Jeeps, etc.
The Jeeps were nightmares. The Oldsmobile Intrigue was so awful that I actually gave it away in a fit of anger. The BMW was fine, but it basically had no backseat at a time when car seats became a fact of life for us, so I had to get rid of it. The Audi and the Volkswagens were all good, but when something went wrong, it was never a simple fix. I current have a Passat and it's now at the point where I'll be getting rid of it soon.
The only truly trouble-free cars I've owned was a Acura TSX Sportwagon and the Nissan Altima. The Altima eventually had 245,000 miles - I had bought the Audi at that point, but I liked the Altima so much that I could not get rid of it. One day, my wife texted me a picture of it on a flatbed and told me she had given it to the Cancer Society. I replaced a frozen rear brake caliper on that car...that was it over 245,000 miles.
None of this helps you. Don't buy a Jeep. Don't buy a German car if you don't want to build an addition on some mechanic's house. You can't buy an Oldsmobile because God smote them and they are no longer a thing.
@zls44, bought a three-year old Japanese car from somewhere in Connecticut that specializes in just-off-lease cars. I forgot where that was, but he showed me the car at the time and I thought he got a great deal for what he got. Perhaps he can chime in.