We have had our well since 1961. I set up my first tank in Jan 2001/ At that time the water tested at pH 7.3 -7.4 and the hardness was 6 dg and the KH was 5 dg. A bout in 2012 a fish keeping friend came for a visit. While there in my pleco fish space she pulled out a digital TDS meter and tested the water.
Now I new at 6 dg GH I have somewhere between 106.8 to under 124 ppm of hardness. That is because each dg if hardness = 17.8 ppm. My friend tested my water at 83 ppm. That was between 4 and 5 dg. That was also when I odered my first TDS meter. This helped me discover another thing about our well water. If we got a number of days of very heavy rain, the TDS dropped down into the low 50 ppm range.
The point is I would not trust a well water test that is a bunch of years old. In fact I cannot trust that my tap tests will not change either due to heavy rains or to a drought condition.
What I do not worry about is that my well water will suddenly go from soft to had or that my pH will suddenly become more alkaline and suitable for rift lake cichlids.
As far as i know decent testing is never cheap. There are no good comprehensive home kits as far as I know. A friend who has a YouTube fish channel gets sent stuff to try, She recently got a quality multi-test product new to the hobby. It tested a lot of things pretty accurately, then I researched the price. It was only $2,000. Now API makes one register to see the price. I have heard it as low as $1,200
Presenting API AQUASPIN, a cutting-edge technology that combines speed and accuracy for the best aquarium and pond water analysis results anywhere, all in just two minutes! Using AQUASPIN is simple – all it requires is a small water sample from your customer, the AQUASPIN photometer and a new disk. The water test (freshwater or saltwater) takes fast and accurate readings of aquarium or pond parameters, including, where applicable, nitrate, nitrite, ammonia, phosphate, carbonate hardness, general hardness, pH, magnesium, and calcium. No need for color comparison or human interpretation, the AQUASPIN technology provides your results accompanied by an API product recommendation all with the click of a button.
I believe they intend this device to be purchased by stores who will them change hobbyists for doing a test with it.
I investigated high quality test equipment. What I discovered is you readily will need to spend in the thousands to get quality reliable resu;ts for multiple parameters.
Finally, when you read that water softeners do not put a lot of sodium into the water and you can drink it just fine, you have to realize that people drinking a few glasses of water vs watering the lawn for 20 minutes are not the same thing. As far as I know sodium does not evaporate. People on restricted sodium diets are advised not to drink water softened with salt.
Do some more homework re softened water for gardening. You will find what I did. However, while the unsoftened outdoor faucet is great for the garden, lawns and often aquariums, it is not so good for cleaning things like cars or windows. Hard water can leave a white film on things when it evaporates. So, the ideal set-up is to have both water sources available for outside uses.
I am pretty sure water softeners have bypasses. You can plumb things accordingly depending on how much you are willing to spend for a plumbers or how much DIY you can handle.