Cost Explorer does all of what you mentioned. UI allows 1 level group by, API does 2. You can filter & group by API Operation (S3 put object), Service (S3), Usage Type (S3 Standard Storage GB/mo), (predefined) Tags and it works brilliantly over even 1 year of data, fast.
I'm really not convinced on what you can do additionally, since you work on the same data exactly (detailed dumps on S3) apart from nicer charts.