Hello Vicky,
first of all, thank you for your feedback!
The system that you describe as "biting hour effect" does not exist, at least in the way you are putting it. There is no time limit on a spot being active. What does happen in the game is that you can overfish the population of fish available in one spot. This is completely dependant on the number of fish caught, but can also be influenced by overfeeding. For more details check out this Q&A
This system of populations being drained has, as you describe, been indeed implemented to create more realism and also encourage the player to try different things.
Your second point of some water bodies not being attractive, clearly comes from a very "meta" position of wanting to make the most possible silver per hour. That is completely fine, as some players enjoy this aspect of the game most.
This is unavoidable though, because this comes down to math and there will logically be always one water body that is "best".
Keep in mind though, that there are many different motivations to play the game and maps might be attractive to other players for different reasons.
Overall, with RF4 we are trying to create a game that encourages and rewards flexibility and creativity. Conditions change and the player has to adapt to stay successfull.
This might not appeal to every type of gamer but it is our philosophy and the soul of our game.
The best suggestion to enjoy RF4 is probably to not constantly look at the "silver per hour", but to set certain target fish for yourself. You will have more fun and the silver will come in as well over time.
And just in case you might have overplayed the game a bit, which we all know can happen in gaming, there is also no shame to taking a break from time to time. Often the game is more enjoyable afterwards!
Tight lines!