Water park fun works the same way with or without the hopping feature on your ticket. Visiting minor parks (Blizzard Beach, Disney Quest, etc.) does not involve or require the hopping feature at any time.
Using two different ticket cards to enter two major theme parks respectively on the same day does not count as hopping. For example you can come from Epcot and then use your Not So Scary ticket to enter Magic Kingdom (after 4 PM on the appointed day). If the "contents" of more than one ticket card have been linked to the same Magic Band, then it requires an administrative move (reprioritizing) to use that Magic Band instead of the ticket card at the second park.