I too visited them years ago and yes it is an incredible sight. A tip I give everyone is to look up the website where they actually give you a pass to go see them. If you don’t do this, you will have to be behind a fence like the rest of the public and view them. I was able to go in and walk around and actually touch them. Years ago some punks that were celebrating spray painted them and spoiled it for the rest of the world.
Hadrian's Wall isn't as old or spectacular but parts of it are worth visiting, especially around Housesteads...nice walking trails along the wall.