What many people dont often do is create their own spells. It takes a lot of time and effort to come up with, and not completely break the game balance. But its really a wonderful part of the game when done within the context of "dont be an asshole gamer"

Creating unique elements for your characters/campaigns is some of the more rewarding experiences ive had with ttrpg.

That being said im too lazy and have generally just played hack n slash/murder hobo type games

But only mostly.

The best gaming experiences ive found are the ones where creativity is rewarded without disrespecting the table and overall group. When you have players collaborating over some idea they think is really good or just exciting to them. If its really dumb and stupid its probably going to be very satisfying when the dm controls the consequences well(even the negative ones!)

Failure should always be made to be simply a different path not a roadblock(sometimes that does mean rolling new character or whole party!)