The best guitar to get is the one that will inspire you to pick it up and play. So it really depends upon the type of music that you want to play. You should think of your favorite band or your favorite couple of songs and get the guitar which gets you closest to that kind of sound.
For example, if you want to learn 60s-70s folk songs like (early) Bob Dylan, CSNY, Joan Baez, then get an acoustic guitar.
If you want to learn heavier stuff like Rock or Metal, then get an electric. Broadly speaking, there are 2 basic kinds of electric guitar: ones with single-coil pickups (Fender-y guitars) and ones with humbuckers (Gibson-y guitars) so you should choose the type that the artists you aspire to emulate play. An electric will require an amplifier, but any amp made in the last 20 years will have a headphone jack so you can play without disturbing those around you.
Once you decide roughly what you're looking for (acoustic/electric single-coils/humbuckers) then it's time to go into a music store and actually try a few. Even though you don't know how to play very much or at all, the way the guitar feels in your hands is the most important thing.
If the guitar feels good in your hands and can make the sounds that you want to hear, that will make all the difference when you come home and sit down and have to choose between playing guitar or watching tv or games or whatever else you might do.