GarageBand is fun, and capable of making surprisingly complex music. Logic Pro is also available on iPad now, but it's only available with a $15/month subscription, so I haven't tried it.

For artists, there are a lot of good tools: Procreate, Art Set 4, Adobe Fresco, Artrage, etc.