My first thought was of
48 Hours Without a Superman , a sweet and funny story which I just adored.
In fact, I liked it so much, just thinking about it gave me the impetus to re-read it, only to discover that it actually has NO red kryptonite in it!
But I'm posting the link here anyway, because if you enjoy red-kryptonite-affected-Superman, you will also enjoy this story.