Hardness and pH do not have to be in sync with each other, you can get soft alkaline water or hard acidic water.
Many common livebearers like Guppies thrive in hard water, so you have no problem to solve. Soft water fish like those from the Amazon area would not do too well in such setups, in which case mixing Reverse Osmosis water (bought from fish store or you can buy your own unit... but they produce a lot of waste water) with tap water can work, alternatively only filling your tank with remineralised RO water water is another option. But any changes to the water hardness must be a gradual thing over a number of weeks, suddenly changing the water chemistry will lead to death.
By "perfect" do you mean 0? What about nitrite levels, which will cause short term toxic issues at concentrations far below the 300mg/l for nitrate?
Other general community fish that thrive in hard water include Blind Cave Tetras; X-Ray Tetras; Lemon Tetras; Red Eye Tetras; False Penguin Tetras. In their own setups, the same can be said of fish (mainly cichlids, but there are some catfish and the odd characin) from Lakes Tanganyika and Malawi.