Was John Hinckley the dumbest would be assassin ever?

Did he really think shooting Reagan would impress Jodie Foster and she'd start dating him? And how dumb do you think he feels now that it turns out Jodie Foster is a lesbian anyway?