Yes, 64bit supports more RAM and is the best for gamers/ developers and pretty much every power user. For an extremely general usage PC with 4GB or less memory, 32 bit will suffice.
Some programs may not have 64bit support, but almost all recognized softwares have a 64bit version.