Just don't understand why Google let you create the account in the first place though...
They don't.
Google store the account in the format without any dots. Every possible combination of dots belongs to that account and can be used to log in with and to send emails to.
The problem is simply that people intend to send to a SIMILAR account eg [email protected], but forget the 123 for example.