Is a Used Sports Car a Money Pit or a Worthy Investment?

Been eyeing a used sports car lately something like a 370Z or maybe a Cayman but I keep hearing horror stories about maintenance costs. On one hand, the thrill of driving one is hard to resist, but on the other, I don’t want to end up spending more on repairs than the car’s worth. Anyone here own a used sports car long-term? How’s the reliability been, and are there any models that won’t break the bank to keep running? Would love to hear your experiences before I take the plunge!