Just buy a 981 series Cayman or Boxster and leave your worries behind. Very very reliable cars. Not only has my 981 Boxster Spyder depreciated very little since I took delivery 8 years ago, but I never had a single warranty repair and even now after 35k miles nothing has malfunctioned on the car.
It might be a nice project car if you have access to cheap labor. I paid $3500 for a spare 986 Boxster S engine a few years back. If you can get it inspected and discover the rough running is related to something relatively minor I’d make that trade all day long. And I love Miatas. But the Boxster is a level above.