Pretty well all 32-bit apps are fine on Vista x64 - I've been using it since the early betas with very few problems. The only exceptions are the small handful of apps that have a driver component, but they all have updated versions that run fine on x64 by now.

The 4GB limitation is fundamental to all 32-bit OSs, so Vista x86 suffers from the exact same problem as WinXP.