You have a very nice TV Fool Report.
Attics are often times horrible places for antennas - especially if there is a lot of metal. It would be useful to know your roofing materials, and if they include metal or terracotta.
Before spending lots of money I'd do the following test. Take a basic, inexpensive, non-amplified
indoor antenna (example like, use what you have) up to your attic and see what you get and don't get. Connect it to a length of new coax (you'll need a female to female coax connector) and then run it to one television. Aim the UHF loop north/south. Run the auto-program on the tv twice. Make a list of what you get and don't get (put them in the order of your TV Fool Report to make it easy for the people here to give recommendations). You might already have what you need to perform such a test, or maybe you can borrow it.
Chances are the little indoor antenna might not be powerful enough in the attic. But it will be a reasonable measuring stick to check conditions in your attic. You might repeat it on top of the television and add that data, too. That would allow a comparison between the living room and attic.
There should be a solution without a rotor. What is needed is an antenna that does not have a strong rejection from the rear, so that if you point it north it will also pick up signals from the south. And if the attic proves to be unfriendly to an antenna, a small outdoor antenna should do fine (others will comment).