I did hear that the rogue archer gets better late game. But then again, when I tried archer, I was expecting the adrenaline I got from play dual wielders. Instead, I got bored instead 
And yes! I did read over your list! I plan on trying the rift mage as many people in this thread have suggested that it is very fun. Though maybe on my other playthroughs I will try knight-enchanter, who knows 
I found archer ridiculously fun for two things - a) sniping and b ) being able to move while attacking. All other classes stand still when attacking. The archer can move, and then you can get a skill upgrade to move even faster.
This means that a) I can hit an enemy from very far away, then slowly walk toward them while shooting or b ) use the grapple hook skill to pull myself close, drop a few mines, and then use Leaping Shot to jump away and shoot out explosive arrows or c) sneak and do the above.
I never played archers in DA before I discovered them in Inquisition. I love that the class works very well ranged, but also up-in-your-face and also benefits from sneak attacks, and all the different jumping talents really makes you see so acrobatic, which I feel even the DW rogue skills miss out on. It's the first time I really felt like I was playing a rogue rather than, well, a warrior who used two daggers.