Yeah the Ruy is pretty good if you like long drawing games.
What is the best opening?

That's because we're amateurs, and we mess up. If you play the Ruy, expect a long slow drawing game. If you want to win, try something like the Parham Attack.

Why would I be bothered if it has a lot of draws at grandmaster level if I'm winning with it?
Obviously the Parham means your almost guaranteed to win against any opposition but I'm not pro enough to use it.

You just choose not to use it, go crazy. I didn't say grandmaster level, I said non-amateur level. The level where you don't go crazy hanging things.

I would say an opening that has balance between Agressive pure tactical and solid principle. takes advantage of what your opponent gives you and then runs with it.
examples
KG (Bishop's gambit specificaly)
Ruy Lopez (I don't Play this much)
Evan's Gambit
QGA (I don't play this)
Dutch Defence
KID
English Opening

The Parahm Attack is 1. e4 e5 2. Qh5. Most beginning principles will advise you against moving your queen out early, although this is a valid, aggressive, and strong opening. It leads to great attacking chances, and can catch many players off guard.

ignore the teenage mutants that try to hijack every forum. Dont argue with idiots, they just drag you down to their level and beat you with experience.
That said, the answer is there isnt a best opening but certainly there are bad ones. My (ok Kasparov's) advice is to develop and play along the same lines as chess history. Play open games/gambits then develop to more closed positions. this type of play will help you lay a foundation of structure and typical piece play to build on for future growth.
You will understand a lot about chess if you start with guccio piano, 4 knights, italian games then move on to the more modern ruy lopez and queens gambit. The details of plans and piece placement will make more sense.
Essentially play things that give you rapid and logical piece development. Avoid "tricks" openings to win quickly. This "all-in" approach works at certain a certain beginner level where simple theats are overlooked by many plays but then when facing more serious opposition it starts to progressively fail to gain results. As their results decline players look for answers and they have to learn ideas that have more effective straetgical plans but lack any of the pattern foundation to build on so they start over. Their results begin to fade against players who they had good results against before and their frustration grows. They usually end up quitting.
My advice is at the beginning level focus on classic late 1800 systems of play. Guccio piano, evans gambit, king's gambits anything where the positions are open and pieces are very active. Look at the games of Morphy, Anderssen , Chigorin, Pillsbury, etc,
Avoid steintiz he was a great thinker and some of his earlier games are great but his later stuff was very wacky as he explored certain concepts
1. e4! e5? 2. Nf3!! Nc6?? 3. Bb5!!