The second one (painful) is correct here. Think of "pain" as a noun and "painful" as an adjective.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.
Davidrock65i think it should be "my hand hurts."Not only, look here: painful feet
Painful is generally used to describe things , mostly bad experiences.