Imagine Leliana's shock at the boost in deadliness to her archery. Not to mention the sudden ability to cast magic. What would her favored skills be in Skyrim? Archery, of course. Light armor, alchemy... Actually she'd probably max out the whole rogue tree.
Edit: I was surprised by how many locations you can discover in Skyrim by just sticking to the road compared to Oblivion.
I made her a follower using the 'Familiar Faces' mod, which basically means I had to create her as a character first and build her playstyle myself, so I made her geared mostly towards Archery, Speech (useless for a follower, yeah...) light armor, sneak, pickpocketing, and lockpicking. Bit of one handed, but she's set to only ever use it when she's being attacked and sometimes on horseback. Doesn't use any magic. So yeah, basically the entire rogue skillset.
Would probably join the Thieves Guild. And the Bard's College. My Warden's more the Companions sort.
Leliana: My love, this ancient writings say this portal is the gate to a world far from the one we know!
H: Far away from anywhere and anyone we know?
L: Yes! A completely different world!
H: I see. So nobody is going to ask us to save the world. Again.
L: We would be lost in a foreign land!
H: Yeah. Lost. Sure. Do you think they have any darkspawn there?
L: I don't know...
H: Mmmm, I see. What are we waiting for?
Draugr kinda look like darkspawn. Warden feels right at home when she's fighting them. :S