This is basically misunderstood by most, even some "experienced" fishkeepers. It is also a complex issue, and would take almost a book to fully delve into, so I will attempt the briefest summary.
Each species of freshwater fish has evolved to function in a very specific environment (water parameters, habitat conditions, numbers of the species, other species, etc). Some fish species are rigid in their need for this environment, while other species have the ability to function well in varying conditions. But one thing must be understood--this is
not an ability to manage in changing conditions in a given aquarium. A species, for example the tetra Pristella maxillaris:
Water parameters: Very adaptable for a tetra. Soft to slightly hard (hardness 0 up to 30/35 dGH), acidic to basic (pH 5 up to 8.0) water, temperature 24-28C/74-82F. In hard water it will not be colourful.
There is a biological reason for this tolerance, and it has to do with the habitats of this species. They occur in different areas that have wide divergence, from very soft/acidic to moderately hard/basic. But this does not mean that an individual fish of the species can adapt to varying conditions, because it cannot. What it does mean is that the species will be fine in very soft/acidic water, and it will be generally fine in moderately hard/basic water, but only if the water in either case remains the same. But as the citation above notes, there is a cost to harder water (for this species, but this actually applies to most soft water fishes).
So, to answer your question aren't all fish as difficult to keep as discus, I would say in a general sense, yes. One must know the requirements of a species respecting the environmental factors I mentioned above, and provide as close as possible. This is the only way to assume we are doing the best for the fish. Any deviance outside these parameters has consequences for the fish, as it affects the functioning of their metabolism, the processes that keep it alive by keeping the blood pH identical to the water around it (which is why fluctuating pH is so dangerous), keeping its tissues fed, its immune system working, etc. These processes are part of the genetic blueprint for each species, and they must be recognized.
A while back, a member posted a video of the species
Hyphessobrycon eques (Serpae or Red Minor Tetra) in a habitat in northern Argentina (if memory serves me) where the water temperature was significantly cooler year round than it is in more northerly (for South America) regions where this species also occurs. The assumption was that the species could therefore be kept in almost any temperature range because of this, and fluctuating temperatures didn't matter. This is not at all the case. The species has evolved to function in cooler water in the geographical area in northern Argentina, but individuals of those fish cannot be plunked into the warmer water of the species populations that occur in say the basins of the Guapore and Paraguay rivers, or that of the upper Amazon, where the water temperature is much warmer. The species in these areas has evolved differently. And as an aside, it is no surprise really that Stanley Weitzman hypothesized that the wide geographical distribution of this species in differing waters likely involved different species. Phylogenetic analysis of a large number of fish collected from each region would determine whether Dr. Weitzman was correct, but given his authoritative status I would not doubt it.
As I have been typing, other members have posted, and one of tyhem makes a very significant point...survive and thrive are not the same thing. Read the citations in my signature block; these are absolute truths we must recognize and accept.