I think you got really lucky. In weather situations Delta would normally not pay for ANYTHING, certainly not for a hotel. When you accepted the rebooking for the next day you accepted to cancel you evening flight, which is entirely your fault. Delta would not take volunteers to accept standbys (which makes sense).
If you write to Delta they will probably give you some miles and in all due respect, I don't think you are due any compensation.