Your training was not wasted at all. Keep in mind that the purpose of this game is for you to enjoy it, not make the most game currency possible. If you find frying npc with beams of scorching death enjoyable, then doing that is worth more to a player of a game than a bit more virtual monies.
Amarr ships often use drones, albeit as a secondary weapons system as opposed to some Gallente ships that use them as their primary weapons. Also - many ships in eve use at least small drones - so your drone training far from being wasted is something everyone should train up some.
As was suggested, try out the oracle. Seems to be not unpopular with folks ratting sansha. Oracle is battlecruiser that uses large guns, so you will be able to fly it now with medium guns or soon with large guns.
Easiest ----> hardest site
- (Faction) Burrow / Drone Collection (lowest)
- (Faction) Hideaway / Drone Cluster
- (Faction) Refuge / Drone Gathering
- (Faction) Den / Drone Gathering
- (Faction) Yard / Drone Surveillance
- (Faction) Rally Point / Drone Menagerie(Faction) Port / Drone Herd
- (Faction) Hub / Drone Squad
- (Faction) Haven / Drone Patrol
- (Faction) Sanctum / Drone Horde (hardest)
(Easiest ----------> Hardest)
Hidden > Forsaken > Forlorn>