The spray bottle works..but make sure they don't notice you doing it, otherwise the link of you+waterbottle is easily made. Also, some indoor cats aren't bothered by water as they have no clue why they're supposed to be afraid of it (outdoor cats however..they know)
Here's the professional's trick: Get yourself some really cheap plastic placemats and some double sided sticky tape, and some baking paper. A fishing rod toy also helps.
Then, you stick the tape to the place mats and put them in the places where the cats are not allowed to come. Leave them there 2-3 weeks minimum. If you need the spot, remove the place mats and cover them with baking paper, so you can reuse them later (and they don't get stuck to each other when you stack em). Otherwise, leave it in place.
Meanwhile, make the other spots where they're allowed to jump more attractive. Add a blanky for snoozing, use a fishing rod toy to entice them to jump over there. Leave little treats there that they love. That way they'll soon associate those spots with the 'The Place To Be'.
Expect place mats to come thundering down, when they jump on them and first experience the sticky tape on their paws and panicking. Expect it to happen less and less, but still once a while, during those weeks. They've always been able to jump on there, so they're bound to try first harder before they stop it all together. And expect them to try again in like 4 months after they've learned not to (just to test it out). Be firm and just readminister the treatment. It's normal behavior, so don't despair. Also, do NOT start this to then NOT finish it. Otherwise they'll just learn to jump there more often and more carefully as you haven' been consistent. (And then it takes longer to train that scouting behavior out of them).
If for any reason they're not bothered by the sticky tape (which I sincerely doubt), you can use other things they don't like that much, like cans with pennies in and a bit of tape on the top so it makes a lot of noise and scares the living daylights out of them when jumping on there. Mine however, are less impressed by that, but some cats really learn their lessons from that. Just expect to put several cans a day back in its spot while they learn the lesson
Lastly, think about the one spot they somehow want to be at, consistently and wonder what's so attractive about it. Is it the highest in the house? Is it near where the action is (where the family/you are a lot), do they get a great overview of the room? Is it an easy passage way to somewhere? What is it about that spot that makes them choose it instead of the spots they're allowed to jump on. If there is a reason, it might be harder to train it out of them and you *might* wanna consider opening it up to them to jump on and putting your things elsewhere..which is something you'll have to do temporarily anyways if you do decide to train them with the placemats. Kitchen counters are easy: it's food. You won't *ever* be able to teach them never to go there, as food is self-rewarding for them. You can only discourage it by doing the place mat thing when you're not cooking and the spray bottle thing when you are.