Absolutely not. Sure, you might need something a little bigger than regular pliers, but you don't need that kind of brawn at all. If you can't tighten it enough to stop a spray or drip, then you didn't install it correctly.
Yes, it just screws-on, but you MUST first wrap the pipe's threads with Teflon tape (at least three times around) to have it seal correctly. After the Teflon tape, you can sometimes dry with nothing more than a hand-tight installation.