Crankshaft sensors are a relatively inexpensive part which can fail over time. Generally speaking Honda Civics of this generation are reliable, although any car that is 20 years old or more is more likely to suffer with parts failing due to age. We would have few qualms about buying another one, particularly if you have been otherwise happy with your previous examples. If you're looking for alternatives, consider the Toyota Corolla.