While I like sake with sashimi a lot and also enjoy it with sushi - with most Japanese food, in fact - I think it shines most at the isakaya rather than the sushi counter. And that makes sense because isakayas came to be as places to stop and drink some sake and have a few snacks. There’s usually some raw fish on the menu, but also grilled, steamed, fried, and stewed dishes, an array which lends itself to pairing with something as varied as sake.
For me, I agree that, if you want to do sake with sushi, junmai ginjo or daiginjo is usually the way to go for most traditional sushi meals. I like the clean, more delicate, fruity, melony, minty profile as a lacy background to let the quality of the fish shine.
That said, daiginjo is not at all my favorite style of sake. I love, love, love yamahai and kimoto – the depth and complexity, higher acidity, and delightful rich funk (this is not a flaw in sake, by the way) is perfect for my palate. I think yamahai is food pairing magic, and a no brainer with things like grilled meats, umami-rich dishes with mushrooms, various earthy vegetable preps etc. Yamahai sake is also a great crossover into pairing with western foods, and can really surprise with funky stinky cheeses, for example.
I am not exactly objective, though, because the brewery that my husband imports, Kikuhime, specializes in the yamahai style, and I think makes the best examples out there. There are also some aged bottlings that will knock your socks off – not at all the dark oxidized style of most koshu, but crystal clear and highly complex. PM me if interested in where to find these in the US, mostly NY and CA. These are not cheap, however, so I’d also recommend checking out Paul Willenberg’s selections, which tend to fall into a more moderate price range. He distributes some terrific breweries like Shichi Hon Yari and Shichida.
I like beverages other than sake with sushi, too, but admit to being fairly stodgy. I usually don’t chose red wine because, though there are some good matches (like with tuna), there are enough bad misses that I’d rather drink something that works better across the board for me, like champagne or Riesling, which are favorites anyway.