I will speak from my limited experience with my hard 8.2 pH water. Though a number of tetras have done well for me, cardinal tetras did not. I can't, of course, say for sure that my water was the problem, and not something else.
Green neon tetras, however, have done relatively well, if you'd...