My experience as a cat owner is that I get better results when my cat sees me spraying it, but it depends on what the problem is. The main reason we end up using a spray bottle is when we need the cats to leave a room and they decide to resist our instruction because they are being playful. A combination of first indicating to our cat what is expected and then spraying her with water to coax her out of her hiding spot has worked very well and while still occasionally necessary, she now realizes what is coming if we leave the room after indicating to her that it is time to go and she will then run out on her own most of the time.
Important caveat: Do not try this if your cat is hiding for fear, only if they are hiding to be playful. You can tell by watching how they behave. If they are out normally and immediately go hide when they realize it is time for them to leave and is a very playful cat, then they are being playful. If they stay hidden when you offer them play, then they are scared.
The one major caveat I have to indicate though is that they do not easily form that connection. When training our cats, we would always go over and spend time being affectionate and friendly with them after a short interval after they did whatever it was they were supposed to do. This way we reinforced that it was not us just being mean to them, but rather connected with their action and showing them that we are still friends. I end up doing it more often than my wife and I've noticed that the cat that requires the most frequent discipline responds more positively to me than my wife.
She is still very affectionate towards me though, so it does not seem to have harmed our relationship any. She knows she can't push back against me, but she also loves to be affectionate with me.