Okay Fire is my favorite but it isnt the best damage output and here is why,

Resistances for Aero and Hydro are almost always less than fire resistance so even thought the Meteorstrike says 475-675@ damage it will actually hit for much less since the resistance brings it down, also since fires status effect is burning, it may cause some damge if they do ignite, but it is usually short lived and low value comparitively.

Cold and Electricity are better since the target usually has less or even no resistance to them and being wet ( from rain or standing in water) increases damage and apparently likelihood of a status effect, elec usually stuns meaning a free turn or so to hurt them or whatever, cold spells can freeze also meaning them missing a turn. ALso Hydro and Aero have Tornado, Rain, Invisible, Featherfall, and healing spells, so very good to have. Not all spells are for combat useage.

Poison ( earth spells) do decent damage but I do not like the persistence and spreading uncontrollable nature of poison, it gets everywhere and spreads, damages whoever comes in contact with it and can be set on fire which is then another different hazard. You can be creative with poison, but I am reticent about its use.

So your not a fan of stabbey, choppy, slashy, crushy, pokey, goodness but in truth melee weapons are better than spells, especially towards the end of game. You will see. Spells are good and useful but a great fighter with a good weapon and utilizing his arsenal of special attack talents is a different sort of better. ANd do not laugh at Archers with good bows and the right skills.

statistically in my latest playthrough the wizard and the ROgue are together killing about 1/3 rd of those that get killed the rest have been chopped into bloody quivering sushi like piles of diced flesh by my Knight and his 2handed sword. He killed 5 enemies with one Whirlwind in an encounter and that is not his first time doing that, and when it happens it is just cool and watch that experience bar go!

But it is a combined arms tactical doctrine, I would not want 3 fighters or 3 rogues or 3 wizards, 1 of each and each working with each other together to win.

Best Luck!
Have fun storming the castle!