Is ~/Applications new with Lion?
~\Applications isn't created during the installation of the OS, you have to create it by yourself. Once you create it, it is recognized as an "application folder" and the Finder will show the proper icon for the folder.

It has been like this since Tiger, at least. I'm not aware if Lion creates it automatically as mine was already there when I upgraded to Lion.