Great place, full of places to see and do, however 2 weeks might push it unless you plan to spend a week on a beach!
Depending on your wants, somewhere like St. Julians, St. George's bay is a good spot, great nightlife, clean beach (great for kids), very good selection of restaurants and it's a short trip to the capital, and there are day trips out to various sites.
The people are great, friendly and service is generally of a good standard. I'm back again (for work) in February and would certainly say it's a must do place.
Oh, check out the big Siege of Malta show, and the WWII exhibition.
Unless you book a package, you can fly with Ryanair down and if you want a nice central hotel close to everything, and cheap but good, Hotel Bernard is the spot.