Meguiar's Ultimate Compound is worth a go before buying a rotary, i'm not going to deny it's gonna be hard work but this stuff really can correct by hand.
As Guy has said, clay won't always tar spots, sometimes something like Autosmart Tardis is required. As long as the clay is getting dirty, it is doing it's job, you should be able to feel the difference after claying, the paint will be silky smooth.
Oh and Super Resin Polish IS a good polish, it is very filler heavy and should mask a lot of the smaller/lighter swirl marks.
As for Lime Prime being a good polish, the simple answer is yes, it also has a little bit of cut so when used with a rotary or DA can remove light swirl marks. It will also leave a perfect surface for the wax to bond too.
Hope that helps a little?
Chris