If you post up some of your uses, some of the vendors can chime in with some of their suggestions. But it seems to me with every floor system you are giving up something to gain something else.
Something like Hell-Fire is probably one of the toughest floor coatings I have seen on here(I believe it has aluminum powder in it), but it doesnt look great IMO, so its not "pretty", again IMO.
One of the other vendors on here has a "newer" ceramic based floor coating system, but I havent seen anybody actually use it. The claims are pretty stellar though.
Epoxy can look great, but its not as tough as other coatings and can be scratched and gouged as well as not being UV stable so it can yellow over time.
Polyurea, Polycuramine, and the other off shoots of Poly are UV stable, but can still be scraped and gouged.
Ghostshield is a pretty great product, but its just a densifier/sealer so you still have that bare concrete look, so again, not a "show" quality product.
"plastic/rubber" tiles look great, but for hard use, I personally wouldnt go with them.
Polishing is another option, but it can be crazy expensive because of the time involved and many many passes with the grinders/polishers at different grit levels. You can polish and stain and get some cool looks. Im not sure how stained/polished concrete holds up to really hard use. It seems a lot of guys that do stained or polished concrete do some type of poly clear coat on it(seen quite a few using Nohr-S).
Porcelain tile most people seem to agree is one of the more "ultimate" floors for a garage, even a working garage. Depending on the tile it can be show quality or a bit more understated. You can buy tile for under $1 a sq. ft. up to $5+, seems the sweet spot is somewhere between $2 and $3 a sq. ft... Install materials are, from my research, around $1 a sq. ft. and then whatever your installation costs(I have a local guy who was going to do mine for $1.50 a sq. ft.). I was going to be all in under $5 a sq. ft.
I am personally going back and forth for my new garage between a full flake polyurea floor or spending ~$1000 more and doing porcelain tile.