In suggests that you are ill; at suggests that you are merely visiting-- but the meanings could be reversed by some speakers. In hospital (BrE) definitely indicates infirmity, I believe.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.