Lingering was great to farm Rhoy the Explorer, but the double spellslot is harsh. Make sure you have a great melee weapon, anything is fine! Pyromancy really shines when you have a weapon to back yourself up, as pyro doesn't fit all situations. You get some of the best spells from him. You'll want to make sure you do Navlaan's questline, later on.
You'll get used to scrolling through spells, that's just a limitation in all the games, unfortunately.
Originally posted by Harrison Ford:Lingering Flame is insanely overpowered, takes practice, though.