[Opinions] Depends on the name (m)
Apollo is pretentious as sin, but I wouldn't consider Aglaia or Niobe pretentious, just very unusual.
Well-known god(dess) names tend to strike me as pretentious. Apollo is a great example. Others would include Adonis, Athena, Hera, Zeus, etc.