And speaking of Rhapsody, Luca Turilli has two solo albums which are really good. Basically Rhapsody without the Rhapsody name. King of the Nordic Twilight is REALLY good.
Also (going through my CD collection): Avantasia, Demons & Wizards, Dragonforce, Dragonland, Freedom Call, Galloglass, Hammerfall, Holy Knights, Kamelot, Labyrinth, Lost Horizon, Nocturnal Rites, Power Quest, Secret Sphere, Thy Majestie
Just to name a few.
There a WHOLE bunch out there with the fantasy style lyrics......
Out of that bunch my favs are probably Avantasia, Galloglass, Kamelot, Lost Horizon and the Luca Turilli CD. Demons & Wizards is good too if you like Blind Guardian - its Blind Guardian's vocalist in a side-project.
Jeff.